Turning #value into a blank cell

[amik]

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

 

[Eduardo]

Hi,
same answer given in your other post
=iferror( A5/b5-1,0)

If this helps click yes, thanks

 

[Mike H]

Hi.

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

Mike

 

[Jimmystix]

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

use an IF combined with an ISERROR so it should read
=IF(ISERROR(A5/B5-1),"",A5/B5-1)