ExcelBanter - Turning #value into a blank cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Turning #value into a blank cell (https://www.excelbanter.com/excel-worksheet-functions/232000-turning-value-into-blank-cell.html)

amik

Turning #value into a blank cell

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

Turning #value into a blank cell

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

If this helps click yes, thanks

"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

Mike H

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

Jimmystix

Quote:

Originally Posted by amik (Post 837927)

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

All times are GMT +1. The time now is 08:09 PM.