| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
