Formula Question:How do you automatically calculate information
How do you automatically calculate information in unhidden cells that contain
a formula to calculate from another spreadsheet that shows data and hidden
cells that have a formula to calculate from another spreadsheet that returns
a Div/0! because data is unavailable without the formula result being Div/0!
because the hidden cells do not contain any data?
It's probably best to suppress the errors in the first place. If you have a formula like
=A1/B1 which gives a #DIV/0! error then you can change to
alternatively you can sum a range, say C1:C10, and ignore #DIV/0! errors with
re: Formula Question:How do you automatically calculate information
In your final worksheet use, IF(ISNUMBER(A1),A1,""), or
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1