Divide by Zero error
Comments
-
Thanks Craig,
IFERROR works good, now I think my issue has changed.
Now I need to be able handle divide by zero error and if there is a value in "Total Spend..." column against the "Food Budget..." which could be 0.
Added new screenshot to help show - "Waynesboro" line. Need to be able to show a negative over/under budget even when budget is 0.
Thanks again,
Todd
-
How do you define a percentage when the budget value is 0?
By "you", I mean you, specifically. Mathematically it has no meaning (is infinite).
What do you want to see as the result of
Budget =0
Spend =445
or Spend = 1 or 1000, as the answer is likely the same.
Personally, I would not return a numerical value, but rather something like "Unexpected Expense!" and the have the RYGB ball be red.
Craig
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!