Giving false with certain answers

Solved/Closed
Nichole - Sep 28, 2015 at 09:26 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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","")))))

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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
0