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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!