EXCEL Formula Help

[Freshy-ZN]

Please help if you can:

Have a cell formated as a percentage. Lets say this is in A1
Need to do a logical test. If the percentage value in A1 is 90% or greater show PASS if <90% show FAIL.

IF(A1 >=90,"PASS,"FAIL") : Doesnt work
IF(A1 >=90%,"PASS,"FAIL") : Doesnt work
IF(A1 >="90%","PASS,"FAIL") : Doesnt work

Formula is in a different cell lets say B1. This is where result needs to be written.

 

[pmbellis]

Excel Formula

Please help if you can:

Have a cell formated as a percentage. Lets say this is in A1
Need to do a logical test. If the percentage value in A1 is 90% or greater show PASS if <90% show FAIL.

% is just formatting, the value is still normal numeric, but /100 ... so ...
=IF(A1<0.9,"FAIL","PASS")

 

[Freshy-ZN]

Of course! Awesome, thanks for that!