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

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

Need help with formula
 

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


On Thu, 11 Jun 2009 12:53:02 -0700, lab-guy
wrote:


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

--
Donna