View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default turn #value into blank cell

OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"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?