Thread: B1 is blank if A1 is zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default B1 is blank if A1 is zero
in B1

=if(A1="","","Something else")

Mike

"woitena1" wrote:

I am trying to format B1 as blank if A1 equals 0. I have tried conditional
formatting and "IF" function and I can not get this to work. Can someone
please tell me how to do this?
Reply With QuoteReply With Quote