Try this:

=IF(C15=D15,0,IF(C15D15,-5,5))

Biff

"Rynefan" wrote in message
...
=IF(C15D15,-5,5)

I am using the preceding formula. How do I change it to reflect the
scenerio of "if c15=d15 than 0" ???

Thanks in advance