Previous Topic Next Topic

Values displayed according to range

Closed
rdd - 8 Jul 2010 à 13:49
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 8 Jul 2010 à 17:56
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

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

Similar discussions

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

2 responses
ps3 network error 80710a06
naf -
Ambucias -

5 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response