View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
woitena1 woitena1 is offline
external usenet poster
 
Posts: 5
Default B1 is blank if A1 is zero

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?