View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna Donna is offline
external usenet poster
 
Posts: 180
Default Need help with formula

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