Need help with formula
Hope this helps
=IF(AND(C4=1,C4<=18),"PEDS"," ")
Mike
"Donna" wrote:
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 dont 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.
--
Donna
|