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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

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,458
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,209
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,144,330
Messages
5,723,740
Members
422,512
Latest member
MHau5

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