IFERROR and value in same formula

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!