I am trying to return "100%" if the result of the formula is "0"
[column A] = Boxes on Hand
[column B] = Target Boxes on Hand
[column C] = Deficit of boxes on hand
[column D] = Deficit percent of target boxes on hand
If target boxes on hand [column B] = 6 and boxes on hand [column A] = 2, then deficit of boxes on hand [column C] =4. The deficit percent of target boxes on hand [column D] is 30%.
However,
If target [column B] = 6 and boxes on hand [column A] = 6, then deficit [column C] =0. Then deficit percent [column D] displays "INCORRECT ARUGUMENT". How do I write the formula to display "100%" in [column D]?
Thanks for your help!
Answers
-
I'm afraid I don't understand the formula you are using for Column D.
How is the deficit 30%? Is it rounded up? A divided by B?
In the 6/6 case I would expect it to return 1 (if you are dividing boxes on hand by target) which would be 100%, or 0 if you are dividing 0 by 6, or DIVIDE BY ZERO error if you are dividing 6 by 0. INCORRECT ARGUMENT suggests a problem with the formula itself.
Can you share the formula or logic you are using?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!