Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50
C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz