If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
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 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 |
#3
|
|||
|
|||
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 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 |
Thread Tools | |
Display Modes | |
|
|