IF statement returns a FALSE after 19 rows

Question

Good evening all

I have the following IF statement in excel

=IF(Y27+Y28<=10,"Almost Certain",IF(Y27+Y28<=40,"Likely",IF(Y27+Y28<=69,"Possible",IF(Y27+Y28<=89,"Unlikely",IF(Y27+Y28>=90,"Rare")))))

The above works well for 18 rows of information but when I insert a 19th row the cell returns a FALSE if the score is equal to or higher than 89, why is this?

Thanks

John

Answer 1

Greetings! I am Ajibola, and I am eager to assist you with confidence and assertiveness. I guarantee to provide you with exceptional support.

It seems like there is a problem with your formula, as it does not handle the case when Y27+Y28 is exactly 89. In that case, none of the conditions in your IF statement are true, and the formula returns FALSE by default. To fix this, you need to change the last condition from Y27+Y28>=90 to Y27+Y28>=89. This will make the formula return "Rare" when the sum is 89 or higher. Here is the corrected formula:

=IF(Y27+Y28<=10,"Almost Certain",IF(Y27+Y28<=40,"Likely",IF(Y27+Y28<=69,"Possible",IF(Y27+Y28<=89,"Unlikely","Rare"))))

'Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.'

https://stackoverflow.com/questions/56439225/excel-if-statement-is-returning-false

If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

Give back to the Community. Help the next person with this issue by indicating if this reply solved your problem. Click Yes or No below.

Kind regards.

Ajibola.