true/false formula

[brindha_shree]

hi..
i have two columns...
one colums is numbers from 0-29
the second column is where i want the result to appear where by if the value is 15 to 20 it must show >15 and if the value is less than 15 it must show ok and it it is more than 20 it shows not valid...
i know we have to use if formula...but how bout if there is more than 2 conditions like more than 15 and the same time less than 20.

 

[PaddyD]

On 2002-10-03 01:07, brindha_shree wrote:
hi..
i have two columns...
one colums is numbers from 0-29
the second column is where i want the result to appear where by if the value is 15 to 20 it must show >15 and if the value is less than 15 it must show ok and it it is more than 20 it shows not valid...
i know we have to use if formula...but how bout if there is more than 2 conditions like more than 15 and the same time less than 20.

try:

=if(and(a1>=15,a1<=20),">15",if(a1<15,"OK",if(a1>20,"Not Valid")))

Paddy

 

[Brian from Maui]

You might trying looking into VLOOKUP if you have more between 15 and 20 conditions.

If column than contains the numbers are unique!
This message was edited by Brian from Maui on 2002-10-03 01:26

 

[Aladin Akyurek]

On 2002-10-03 01:07, brindha_shree wrote:
hi..
i have two columns...
one colums is numbers from 0-29
the second column is where i want the result to appear where by if the value is 15 to 20 it must show >15 and if the value is less than 15 it must show ok and it it is more than 20 it shows not valid...
i know we have to use if formula...but how bout if there is more than 2 conditions like more than 15 and the same time less than 20.

AND(A1>15,A1<20) would express 2 conditions... However, the following would also suffice for the problem you describe...

=IF(LEN(A1),IF(A1<=15,"Ok",IF(A1<20,">15","Not Valid")),"")

 

[brindha_shree]

Paddy..Aladin...
Thank you very very much..
it works really good..
ahh..Sorry i wasnt thinking bout vlookup..just the if fucntion..


Regards,
Brindha
This message was edited by brindha_shree on 2002-10-03 01:28