Solved Need assistance with IF Function

February 1, 2018 at 10:02:57
Specs: Windows 10
Can you assist me with IF function on the following?

0-9999 = 0.205
10000-19999 = 0.185
20000-29999 = 0.175
30000 + = 0.150

So far, I have the following but am missing a piece in the middle
=IF(E115<10000,0.205,IF(E115>29999,0.15,0.185))


See More: Need assistance with IF Function

Report •

#1
February 2, 2018 at 14:58:56
✔ Best Answer
You were close, try this:

=IF(E115<10000,0.205,IF(E115<20000,0.185,IF(E115<30000,0.175,0.150)))

See how that works.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question