Values displayed according to range

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Im trying to reference a specific cell then use the IF function to display a value according to where it falls within this specific range.
X<1.5 mil=$0
1.5 mil.<X<2 mil.=$250
2mil<X<3 mil=$500
3mil<X<4 mil=$1000
4 mil<X<5 mil=$1500
5mil<X=$2000

This is what I have =IF(R54<1500000,0, IF(1500000<R54<2000000,250, IF(2000000<R54<3000000,500,IF(3000000<R54<4000000,1000,IF(4000000<R54<5000000,1500, IF(5000000<R54,2000))))))


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
=IF(R54<1500000,0,IF(R54<2000000,250,IF(R54<3000000,500,IF(R54<4000000,1000,IF(R54<5000000,1500, 2000 )))))