IF(AND formula

I am using Excel 2013

I want a formula to tell put in F2 “A”, “B”, “C”, “D” based on a number in B2; the formula I tried after looking stuff up is this



What I get back is FALSE – “39” is currently in B2 – so I need a “D”. Not sure what is wrong with formula

Here is more information

A = 1-5, 21-26

B = 6-10, 27-32

C = 11-15, 33-38

D = 16-20, 39-44

Not sure if this matters but the value in B2 will always be 2 digits, so 2 = “02”


Oh – also the value in B2 is also a formula, so I’m thinking I need to put in another fomula entry to indicate I need “F2” to evaluate the value in B2 not the formula…?


Thanks for any help

By: Travis

Leave a Reply

Your email address will not be published. Required fields are marked *