IFERROR and value in same formula

Tammy Luther

Hi, Hope I can clearly explain what I am doing.

I would like a cell to show a blank if there is an error, but if no error, I want the value in the cell it is pointing to to put the same number in the formula cell.

Example:

if there is #DIVIDE BY ZERO - then leave blank; if there is a value, then put that same value in the cell.

If the error - the cell would be blank. If there is a number (say 85.7, then I want the 85.7 put in the cell. This value could change with each row of data.

Hope I explained what I am looking for clear enough to get a response.

thanks

Paul_S_SBP

Hello,

Is this what you are looking for or have I misunderstood?

=IFERROR(result@row, "")

Paul_S_SBP

If you want to combine the Formula and Result columns, this would work:

=IFERROR(value@row / [Divide by]@row, "")