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
|