I/E Apportionments
- This topic has 1 reply, 2 voices, and was last updated 9 years, 2 months ago by
.
-
Posts
-
Your comments please: Good evening
Can you advise if each input box has to be entered singly?
I am thinking if (say) an annual sales/expenditure budget can be entered and then spread across the periods via a profile ( eg :days per month )
Thank you
Barry
Hello Barry, and thank you for your question.
Yes that is correct, you will have to enter each amount individually. although you could enter a formula to enter the amounts, by either doing that in the cells themselves and copying this across the months, or you could add an additional sheet with your data and then link these to the data cells.
If you do this, you must make sure that the amounts are without decimals, so use the rounding formula: +round(‘your formula’,0).
The last cash flow forecast I did, I needed add details regarding our payroll and used an added sheet with quite complicated data on it, then simply linked the totals to the cash flow data sheet.
I hope that answers your question.
- You must be logged in to reply to this topic.