Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function for inbetween cell values
Hi,
I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 <is inbetween values 1 and 100,"YES", "NO") I can't figure out how to tell Excel the inbetween part? do I use A1=1:100 or 1<A1100? Thanks a lot for your help, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function for inbetween cell values
One way:
=IF(AND(A11,A1<100),"YES","NO") In article , Ivano wrote: Hi, I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 <is inbetween values 1 and 100,"YES", "NO") I can't figure out how to tell Excel the inbetween part? do I use A1=1:100 or 1<A1100? Thanks a lot for your help, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function for inbetween cell values
try
=if(and(A=1,A<=100),"yes","no") "Ivano" wrote: Hi, I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 <is inbetween values 1 and 100,"YES", "NO") I can't figure out how to tell Excel the inbetween part? do I use A1=1:100 or 1<A1100? Thanks a lot for your help, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function for inbetween cell values
You want the And function, as in:
=if(and(a11,a1<100),true,false) -- Regards, Fred "Ivano" wrote in message ... Hi, I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 <is inbetween values 1 and 100,"YES", "NO") I can't figure out how to tell Excel the inbetween part? do I use A1=1:100 or 1<A1100? Thanks a lot for your help, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function for inbetween cell values
You could also set the formula up to allow you to put the Minimum (C1) and
Maximum (C2) limits in another cell and not have to go in and change the formula itself if this condition arizes regularly. =IF(AND(A1C1,A1<C2),"YES","NO") Vaya con Dios, Chuck, CABGx3 "Ivano" wrote: Hi, I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 <is inbetween values 1 and 100,"YES", "NO") I can't figure out how to tell Excel the inbetween part? do I use A1=1:100 or 1<A1100? Thanks a lot for your help, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function for inbetween cell values
thanks AND thanks AND thanks AND thanks .... get it "AND" : ))
"Ivano" wrote: Hi, I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 <is inbetween values 1 and 100,"YES", "NO") I can't figure out how to tell Excel the inbetween part? do I use A1=1:100 or 1<A1100? Thanks a lot for your help, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to select second-to-last non-empty cell | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
set hypothetical values for a cell | Excel Worksheet Functions |