Hide Formula Within Cell?

[gtudor]

Quick question.

Is their a way to hide the cell data that is outputted from a formula, in this instance the '£' & '-' ? Capture.JPG

The formula within the cell is a simple =L14 -(L14*M14)

Thanks for your help.

[Spencer101]

You could use conditional formatting to turn the text white if the result is zero...

[icestationzbra]

try Conditional Formatting and match the font colour with the background colour of the cell.

[Cutter]

Or do you just want to show a blank if there is no value yet? If so maybe this:

=IF(L14="","",L14 -(L14*M14))