Giving false with certain answers

Solved/Closed

Nichole - Sep 28, 2015 at 09:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 29, 2015 at 11:56 AM

Hello,

I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE. For example: if I have 2341 pieces received and 32 pieces rejected, I will receive a false, however if I have 200 pieces rejected, it will give me a B.

=IF(F29>=99,"A",IF(F29=98,"B",IF(F29=97,"C",IF(F29=96,"D",IF(F29<=95,"F","")))))

Giving false with certain answers
Little alchemy answers - Guide
How to answer call with volume button android - Guide
Spoken answers - Guide
Remove false from if statement ✓ - Excel Forum
Removing false in excel ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 29, 2015 at 11:56 AM

Hi Nichole,

You mention 2 values: received and rejected pieces, but you formula only mentions 1 cell: F29.

Is there something you are not telling us?

Best regards,
Trowa

Similar discussions

Removing " false" value in "IF"

WhatsApp Bluetooth calls issue

Removing "FALSE" from an IF statement with a VLOOKUP

Need help to remove FALSE from cell

No Timer Tick interrupt

Similar discussions

Subscribe To Our Newsletter!