Hiding negative numbers

H

hiwatt

Anyone know how to hide negative numbers in cells? Like
when a function or formula returns a negative.
 
P

Peo Sjoblom

You can use a custom format

General;

another way would be to use conditional formatting and format negative
result with white fonts,
both those methods will only hide it, if you want only positive results
otherwise nothing

=IF(A1<0,"",A1)
 
Top