Hi all,
I have few formulas in some cells. Is there anything that can help me turn any cell with #DIV/0! or #Value! symbol into blank?
Thank you all,
VBisgreat
Hi all,
I have few formulas in some cells. Is there anything that can help me turn any cell with #DIV/0! or #Value! symbol into blank?
Thank you all,
VBisgreat
VBisgreat,
What you're looking for is the ISERROR formula. ISERROR will check if a value returns an error, and if so, outputs true (if not, it outputs false). Using this knowledge, you can combine it with an IF formula to take advantage of the true/false output and set the output to desired. In this case, if it returns true, the output should be "".
Using an example:
- If you are dividing cell B1 by cell A1, you would use =B1/A1
- However, if A1 = 0 then the result will be an error.
- To avoid the error ouput, you can change the formula to the following:
- =IF(ISERROR(B1/A1),"",B1/A1)
- Now the formula will only show the result if A1 is not 0, and if it is 0, the formula will show a blank cell
Hope this helps,
~tigeravatar
Thank you very much!!!
VBisgreat
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks