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