Assign a specific value based on whether another value falls within varying ranges.

[Smudge.Smith]

I would like to assign a specific value to a cell based on another cell number.

EG If D5 is greater than or equal to 5 then F5 = 5, If D5 is greater than 0 but less than 5 then F5 = 1, If D5 = 0 then F5 = 0, if D5 is less than 0 but more than minus 5 then F5 = -1, if D5 is greater than than or equal to -5 then F5 = -5

I really don't know how to do this because I get my greater than and less than signs mixed up.

Would really appreciate some hekp with this

Graphic reperesentation:-


-5 -4 -3 -2 -1 0 1 2 3 4 5
-----------------------------------------------------------------------------------------
(-5) ( -1 ) (0) ( +1 ) (5)

[bebo021999]

Try this:
=IF(D5>=5,5,IF(D5>0,1,IF(D5=0,0,IF(D5>-5,-1,-5))))

[Smudge.Smith]

Try this:
=IF(D5>=5,5,IF(D5>0,1,IF(D5=0,0,IF(D5>-5,-1,-5))))

Sir, you are an absolute star ! That works for me.
I thank you for your rapid response. Your assistance is greatly appreciated.