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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!