if function with different criteria

[Haz]

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

 

[Raz]

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)))

 

[muddan madhu]

try this

=IF(OR(E10=0,E10=8),0,IF(E10=7,7.5,IF(E10=9,-7.5,"")))

 

[Gary''s Student]

=(E10=0)*0+(E10=8)*0+(E10=7)*7.5-(E10=9)*7.5

 

[Haz]

thanks, this worked perfectly

try this

=IF(OR(E10=0,E10=8),0,IF(E10=7,7.5,IF(E10=9,-7.5,"")))