Dividing a value under "1" i.e. 0.71 isn't working
OK, so I have a sheet that's giving me some details on contract spend.
One column is telling me the remaining value in a contract, another column is telling me how may weeks are left until the contract expires - i then have a 3rd column that is calculating how much weekly spend is available before the contract expires.
This is all quite simple using =[Remaining Contract Value]22 / [Weeks1]22 BUT when the number of weeks drops below 1 (i.e. 0.71 weeks as shown in the attachment), i can't get the correct answer as you'd have multilpy the remaining value X the weeks left to get the answer?!
This is probably very simple but i'm stuck, any help would be appreciated!
Answers
-
Try using something like this...
=IF([Weeks1]@row >= 1, [Remaining Contract Value]@row / [Weeks1]@row, [Remaining Contract Value]@row * [Weeks1]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!