Need help with formula

[Donna]

Hello all.

How do you write a formula for cell K1 to read “PEDS†if the age in cell C1
is from 1 – 18?

I don’t want PEDS to appear in K1 if C1 contains no data. I only want PEDS
in K1 if I manually enter an age from 1 to 18 in C1.

Thanks for the help.

 

[lab-guy]

Hope this helps

=IF(AND(C4>=1,C4<=18),"PEDS"," ")

Mike

 

[Gord Dibben]

Just a suggestion................do not return a space character as the
second option.

=IF(AND(C4>=1,C4<=18),"PEDS","")

Leaves the cell blank but does not add a space.


Gord Dibben MS Excel MVP