Formula questions

[Guest]

I am trying to write a formula that checks the number in cell B4 and if it is
between 1 and 52 then "A" would be placed in cell B6 but if the number was
greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect.

Where do I start. What fomula should I use.

Thank you for your help

 

[Bob Phillips]

In B6: =IF(AND(B4>1,B4<=52),"A"),B4<99,"B",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thank you Bob for the quick answer. That is exactly what I was looking for.

 

[Guest]

Bob,

I get an error when using this formula. Could you please check, as I it's
above my head.

 

[Bob Phillips]

Sorry, my error

=IF(AND(B4>1,B4<=52),"A",IF(B4<99,"B",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thank you again

Sorry, my error

=IF(AND(B4>1,B4<=52),"A",IF(B4<99,"B",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)