ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you use two inequalities with the IF function ie IF 10 (https://www.excelbanter.com/excel-discussion-misc-queries/10418-can-you-use-two-inequalities-if-function-ie-if-10%3Ce5%3C20.html)

CRICKETERRY
Can you use two inequalities with the IF function ie IF 10
 
In EXCEL I know you can use the IF function with one inequality eg IF E98
THEN....But can you make it do two inequalities at once eg if E9 is between
100 and 200 THEN... Any help much appreciated

ExcelBanter AI
Answer: Can you use two inequalities with the IF function ie IF 10
 
Yes, you can use two inequalities with the IF function in Excel.

To check if a value in cell E5 is between 10 and 20, you can use the following formula:
  1. =IF(AND(E510,E5<20),"Value is between 10 and 20","Value is not between 10 and 20")

Here, we have used the AND function to check if both inequalities are true. If both are true, then the IF function returns "Value is between 10 and 20", otherwise it returns "Value is not between 10 and 20".

Similarly, to check if a value in cell E9 is between 100 and 200, you can use the following formula:
  1. =IF(AND(E9100,E9<200),"Value is between 100 and 200","Value is not between 100 and 200")

Again, we have used the AND function to check if both inequalities are true. If both are true, then the IF function returns "Value is between 100 and 200", otherwise it returns "Value is not between 100 and 200".

Hari Prasadh
Hi,

One way

=IF((E9100)*(E9<200),TRUE,FALSE)

You can use And, OR statement within IF.

Thanks a lot,
Hari
India

"CRICKETERRY" wrote in message
...
In EXCEL I know you can use the IF function with one inequality eg IF E98
THEN....But can you make it do two inequalities at once eg if E9 is
between
100 and 200 THEN... Any help much appreciated

Bob Phillips
=IF(AND(E9=100,E9<=200), True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CRICKETERRY" wrote in message
...
In EXCEL I know you can use the IF function with one inequality eg IF E98
THEN....But can you make it do two inequalities at once eg if E9 is
between
100 and 200 THEN... Any help much appreciated

Cricketerry
Many thanks for taking the time to reply- I'm still learning! Terry Sealey

"Hari Prasadh" wrote:

Hi,

One way

=IF((E9100)*(E9<200),TRUE,FALSE)

You can use And, OR statement within IF.

Thanks a lot,
Hari
India

"CRICKETERRY" wrote in message
...
In EXCEL I know you can use the IF function with one inequality eg IF E98
THEN....But can you make it do two inequalities at once eg if E9 is
between
100 and 200 THEN... Any help much appreciated

Cricketerry
Many thanks for your reply. A great help. Terry Sealey

"Bob Phillips" wrote:

=IF(AND(E9=100,E9<=200), True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CRICKETERRY" wrote in message
...
In EXCEL I know you can use the IF function with one inequality eg IF E98
THEN....But can you make it do two inequalities at once eg if E9 is
between
100 and 200 THEN... Any help much appreciated


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com