IF Function with range of values

[desertfox]

My Scenario is as follows:-

If the Value is >=1, <=2 then the value will be 4.5
If the Value is >2, <=4 then the value will be 4.5
If the Value is >4, <=7 then the value will be 80%
If the Value is >7, <=9 then the value will be 60%

I tried the following Formula:-

=IF(C17=0,0,IF(C17<=2,4.5,IF(C17>2,4,IF(C17<=4,4,IF(C17>=4,C17*0.8)))))

but not working.

Please anybody can help?

Regards
Desert Fox

 

[etaf]

you have 4.5 twice
and you also have 80% and 60% of what ?
C17?

=IF(C17<1,0,IF(C17<=4,4.5,IF(C17<=7,C17*0.8,IF(C17<=9, C17*0.6, "greater than 9"))))

 

[gaz_chops]

Create a small table
ColA ColB
1
2 4.5
4 4.5
7 80%
9 60%

use formula
=LOOKUP(C7,$A$1:$A$5,$B$1:$B$5)

 

[gaz_chops]

Sorry should be

ColA.....ColB
0.........0.0%
1.........4.5%
4.1......80.0%
7.1......60.0%
9........60.0%
9.1.....> 9

 

[krykm]

=IF(AND(C17>=1,C17<=2),4.5,IF(AND(C17>2,C17<=4),4.5,IF(AND(C17>4,C17<=7),C17*0.8,IF(AND(C17>7,C17<=9),C17*0.6))))

I hope that helps

 

[desertfox]

Many Thanks, It works now.