Im a novice at this, but had a similar problem with conditional
formulas. I think I may have what you are looking for.
=if(or(C500C499,O500C500),(0),30*(C500-O500))
Something that helped me greatly was clicking on my formula in the
formula window. As you move the cursor back and forth over the formula,
it displays what that portion of the formula does. You may already know
that.
Let me know if that formula works for you.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/