|
| 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
June 11th, 2009, 08:45 PM
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 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
June 11th, 2009, 08:53 PM
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 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
June 11th, 2009, 10:51 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
