Previous Topic Next Topic

Values displayed according to range

Closed
rdd - Jul 8, 2010 at 01:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 8, 2010 at 05:56 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 8, 2010 at 05:56 PM
=IF(R54<1500000,0,IF(R54<2000000,250,IF(R54<3000000,500,IF(R54<4000000,1000,IF(R54<5000000,1500, 2000 )))))
0

Similar discussions

The page cannot be displayed. (80710a06)
anymay -
RAY -

2 responses
ps3 network error 80710a06
naf -
Ambucias -

5 responses
page cannot be displayed
Chillwave -
Ambucias -

3 responses
Ps3 network problem
dan lekah -
Ambucias -

3 responses
The page cannot be displayed.
montymunian1947 -
ac3mark -

1 response