Thread: When I have a formula in a cell, how can I make it come up blank?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default When I have a formula in a cell, how can I make it come up blank?
=IF(E2="","",E2+E3)
or
=IF(ISBLANK(E2),"",E2+E3)
--
David Biddulph

"Vi" wrote in message
...
Example, I have the formula e2+e3 in cell e4. I have data in cell e3 but
nothing in cell e2. I want e4 to be blank instead of putting in a zero.
Thanks.


Reply With QuoteReply With Quote