IF Error Add to Formula
Hello All:
I would like to ad IFERROR to the Below Formula so when the Stories is 0, I do not get a #DIVIDE Error. =$Stories$11 Represent the Total
=$Stories$11 / Stories@row
Thanks
Answers

You probably don't want an IFERROR as that is more for trapping errors
Try this
= IF(Stories@row=0, [Stories]11,[Stories]11 / Stories@row)
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com

Hey @Kaleb
=IFERROR($Stories$11 / Stories@row,"")
As written above, the "" at the end will make the cell blank if an error occurs. If you wish to display something else, enter text in between the quotes, if you want to enter a number, eg zero, enter the value after the comma and in place of all quotes.
There is a way to convert your formula above to a column formula. This will allow the formula to always automatically be added to any new row.
Create a summary field (right hand menu ribbon) and have the field = $Stories$11
replace the $Stories$11 in the formula above with the summary field you just created (the reference for the summary field is Summary field name followed by pound sign).
Kelly

I Missed the quotes. Got it, Thanks.

Great! If you need any more instruction on the Summary field, let us know. Using the summary field in your formula would make your formula much more robust.
Kelly

My Second Row Results is 500%. It Should 0%

Can you share a screenshot please. As Brent was pointing out, IFERROR only works if there is an error. A 'False' statement is not an error.
Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!