Hi there,

This may be very simple, but I don't know how to search for it properly because I can't seem to find the answer.

I want to use a conditional format, but if the value is greater than 0, I'd like the answer to the equation to show, not the equation. Here's what I have now:

=IF(B30-B29<0; "0";IF(B30-B29>0;"=B30-B29")

and what shows in the cell is =B30-B29, but i'd like the answer to show, not the equation...

Thank you!

Mugs