multiple if statements for condition

[kamelkid2]

i cant figure out an if statement for a range of numbers



what i need is:

if HU$2*HU$23<50, display 3
if HU$2*HU$23>50, but less than 101, display 2.5
if HU$2*HU$23>100, but less than 201, display 1.75
if HU$2*HU$23>200, but less than 301, display 1.5
if HU$2*HU$23>300, but less than 401, display 1.25
if HU$2*HU$23>400, display 1.15

thank you for any help

[6StringJazzer]

Try this

Please Login or Register  to view this content.

However, this may not be exactly what you need because your description does not address one boundary condition. What do you want to happen when the value is exactly equal to 50?

[kamelkid2]

that was an oversight on my part. ill change on of the conditions to 51 or 49.

i did however get it to work with something like this:

=IF(HU$2*HU$23>=450, "1.15", IF(HU$2*HU$23>=300, "1.5", IF(HU$2*HU$23>=200, "1.75", IF(HU$2*HU$23>=100, "2", "3" ) ) ) )

but i will try out your programming as it seems much more efficient and easier to look back at 2 years from now

[kamelkid2]

yes what you have supplied me work perfectly. thank you so much