The number of right facing parenthesis "(" must equal the number of left facing parenthesis ")".
You need a couple more ")" at the right end.
That doesn't make the formula correct however. I believe it should look like this...
=IF(C1C2,C2-C1,IF(C1<C2,C2-C1,""))
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)
"Jennifer"
wrote in message
ng.com...
Hi,
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))
Thank you.