This topic contains 1 reply, has 2 voices, and was last updated by  bowraven 1 year, 10 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1040

    Berfcca
    Participant

    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

    #1041

    bowraven
    Keymaster

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.