Need help with formula

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top