# true/false formula

#### brindha_shree

##### New Member
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.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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")))

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

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")),"")

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

Replies
12
Views
458
Replies
1
Views
113
Replies
3
Views
275
Replies
6
Views
295
Replies
2
Views
118

1,220,966
Messages
6,157,124
Members
451,399
Latest member
alchavar

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back