Thread: turn #value into blank cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default turn #value into blank cell
=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?
Reply With QuoteReply With Quote