Dividing a value under "1" i.e. 0.71 isn't working

Options

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!


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!