View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lab-guy lab-guy is offline
external usenet poster
 
Posts: 17
Default 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