Thread: (B2-A2)=0; How to get a blank and NOT '0'
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
  
Posts: 1,670
Default (B2-A2)=0; How to get a blank and NOT '0'
=if((B2-A2)=0,"",B2-A2)



"Rum" wrote:

Hi,

When I do (B2-A2) I get a '0'.

How can I have a blank cell as a result even if the answer is '0'?

Thanks
Regards
Rum
Reply With QuoteReply With Quote