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!