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 January 16, 2023 - 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
Answer call with volume button android - Guide
Turn off spoken answers - Guide
True or false : if the system shows an error message: "no timer tick interrupt" it could be a faulty motherboard. - Motherboard Forum

1 reply

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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"

Removing "FALSE" from an IF statement with a VLOOKUP

how to login my yahoo without security question

Need help to remove FALSE from cell

Forgot yahoo 2nd security question + password

Removing False Value

Similar discussions

Subscribe To Our Newsletter!