HELP! Formula if one cell is filled, pre-populates the rest for Weekly, Monthly or Annual

I am trying to create a personal budget sheet with three columns for inputting data either weekly monthly or annually. How can I make it that if I enter date in one cell, say monthly; that it automatically calculates the weekly amount and the annual amount and vice-versa if entered into weekly or annual cells?

Any help would be greatly appreciated as I am going nuts trying to work it out

Perhaps you can have a column for the type of amount (A for Annual, M for Monthly, W for Weekly etc) together with a column for the amount, and then you can derive the 3 columns from those.

Hope this helps.

Pete

Thanks Pete,

That seems to have done the trick but I need to hide [FALSE] if there is no date entered into a particular cell as will sometimes be the case depending on the client and what their income and expenditure sources may be.

Any suggestions how to hide the [FALSE] notification in a results cell?

Thanks,

Dave

Something along these lines:

=IF(date_cell="","",your_existing_formula)

Hope this helps.

Pete