Got myself really stuck with something I should know better.

I have values in column D of my spreadsheet which will range from 2 to 11

I want to write a formula to return a value in column E along the following lines

When Col D cell 3 <= 3.5 then 1

When Col D cell 3 >= 3.6 Or D3 <= 7.4 then 0.6

When Col D cell 3 <= 7.5 or D3 <= 11 then 0.4

I thought it would be simply

IF(AND(D3<=3.5,1,D3>=3.6,D3<=7.4,0.6,D3<=7.5,D3<=11,0.4))

eg: (and values between)

D E

3.5 1

3.6 0.6

7.5 0.4

Any ideas or help greatly appreciated