Hello. I am creating a formula in A2 that will show different values depending on the errors committed. For example, if the analyst does not have any errors, the value will be "10". If the analyst committed one error, the value will be "9". But if the analyst committed more than five errors, the value will be "0". I'm wondering if this is possible with an IF formula.

Does the formula need to actually count the errors or

is the number of errors a digit in a cell like B2?If it's the latter, then something like this should work:

=IF(B2>=5,0,IF(B2=4,6,IF(B2=3,7,IF(B2=2,8,IF(B2=1,9,10)))))

MIKE

And even shorter...unless of course an analyst can commit 4.5 errors. Shared responsibility, perhaps? ;-) =IF(B2>4,0,10-B2)

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll

Are you looking forward to the Xbox Series X?

Discuss in The Lounge

Poll History