IF formula returning only false value

Question

I have typed in a basic IF formula to my Excel spreadsheet to return the value "PASS" if a cell is greater than another and "FAIL" if it is not, but the formula will only return the value "FAIL". The formula is =IF(W20>X20,"PASS","FAIL"). Cell X20 is another formula that pulls a number based on if a certain text is contained in a different cell (=IF(ISNUMBER(SEARCH("GW",T20 )),"82.0","84.5") and the cell W20 is a formula that subtracts a number from 100 if the cell contains the same certain text, and does not change the number if it does not (=IF(OR(ISNUMBER(SEARCH("GW",T20))),100-V20,V20).

Answer 1

Hi respected Alisha McGlynn,

Thanks for your valuable feedback and I appreciate your kind words.

If you find our suggestions helpful, you can also use the feedback tool below our reply to submit your feedback for us (pictured below), which will definitely help others in the community who are experiencing similar problems to find solutions to their problems more quickly.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best wishes

Waqas Muhammad

Answer 2

Dear respected Alisha McGlynn,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, you need to remove the quotes around the numbers 82.0 and 84.5. By removing the quotes, Excel will treat them as numeric values instead of text.

The corrected formula is:

=IF(ISNUMBER(SEARCH("GW", T20)), 82.0, 84.5)

Note that I have removed the double quotes around 82.0 and 84.5.

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 3

It worked!!!! Thank you, Kevin!

Answer 4

Change the formula in X20 to (remove the quotes):

=IF(ISNUMBER(SEARCH("GW",T20 )),82,84.5)

Kevin