View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Turning #value into a blank cell

Hi.

=IF(ISERROR( A5/B5-1),"",A5/B5-1)

Mike

"amik" wrote:

I have this formula A5/b5-1

Somtimes due to a pivot table there will be no numbers in the A5 and B5.
Curently it gives mea #value. is there a way to get this to be blank?

I would appreciate any help