IFERROR and value in same formula
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
Answers

Hello,
Is this what you are looking for or have I misunderstood?
=IFERROR(result@row, "")

If you want to combine the Formula and Result columns, this would work:
=IFERROR(value@row / [Divide by]@row, "")
Help Article Resources
Categories
Check out the Formula Handbook template!