this if you may enter other values
=IF(A1=0, 0, IF(A1=8, 0, IF(A1=7, 7.5, IF(A1=9, -7.5, "wrong value"))))

or
this if you r sure that there will be no other value entered
=IF(A1=0, 0, IF(A1=8, 0, IF(A1=7, 7.5, -7.5)))


"Haz" wrote:

hi,

i need an if function I think that will do the following:-

if E10 is 0 then E20 shows 0 or blank
If E10 is 8 then E20 shows 0
If E10 is 7 then E20 shows 7.50
If E10 is 9 then E20 shows -7.50

I have tried to get an if function to do this but can't get it to work
properly, maybe i need a different function?
Any help would save me a great deal of time and would be appreciated.

Thanks
Haz