How to Get IF and OR Formula to work for 3 IF statements ?

General discussion on MS Excel and its spreadsheets.

How to Get IF and OR Formula to work for 3 IF statements ?

Postby Champ_AN » Mon Sep 15, 2014 6:24 am

Hi everyone,

I cannot get this formula to work and have tried everything I can think of, please help =IF(J4<=H4,"PASS")OR(J4>H4,"FAIL")OR(J4=0,"N/A")

Please help me..
Thanks in Advance,
Champ_AN
 
Posts: 19
Joined: Tue Mar 25, 2014 6:34 am

Re: How to Get IF and OR Formula to work for 3 IF statements

Postby Micheal T. Leo » Mon Sep 15, 2014 12:06 pm

Hi,

=IF(J4<=H4,"PASS",if(J4>H4,"FAIL",if(J4=0,"N/A")))

BUT these conditions are not correct. For exampls if J4=0 can it be <H4 ? If yes you will get" PASS" not "N/A". If H4<0 and J4=0youill get " FAIL" not "N/A".
You need to review your conditions in the light of possible values.
Please try the code given below:
Code: Select all
=IF(J4=0,"N/A",IF(J4<=H4,"PaSS","FAIL"))

Thanks,
Micheal T. Leo
 
Posts: 26
Joined: Mon Mar 24, 2014 6:26 am


Return to MS Excel- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron