Thread: Cell empty if value is 0?????
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
  
Posts: 1,069
Default Cell empty if value is 0?????
Try this in F160:

=IF(C160=0,"",C160)

Hope this helps,

Hutch

"hoyos" wrote:

I have the following formula in cell "F160"
=IF($C160,C160,0)

If I wish cell "F160" to be empty if cell "C160" = 0
How do add to the formula
Reply With QuoteReply With Quote