Solved IF formula for Tiers in Excel

September 3, 2020 at 10:18:39
Specs: Windows 10
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.

See More: IF formula for Tiers in Excel


#1
September 3, 2020 at 10:44:13
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

http://www.skeptic.com/


Reply ↓  Report •

#2
September 3, 2020 at 10:49:18
Here is an even shorter version

=IF(B2>=5,0,10-B2)

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#3
September 3, 2020 at 18:10:12
✔ Best Answer
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


Reply ↓  Report •
Related Solutions


Ask Question