true/false formula

brindha_shree

New Member
Joined
Sep 23, 2002
Messages
23
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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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

New Member
Joined
Sep 23, 2002
Messages
23
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
 

Forum statistics

Threads
1,181,338
Messages
5,929,389
Members
436,665
Latest member
MonkeyNotDonkey

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top