Need help with formula

  • Thread starter Thread starter Donna
  • Start date Start date
D

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.
 
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
 
Back
Top