I started out with what I thought would be a simple project to solve fluctuating budgets problem.
What I basically have is a 4 columns in a spreadsheet labeled "Weekly" "Fortnightly" "Monthly" & "Yearly"
I wish to be able to fill in a figure in ANY of the 4 columns and extrapolate the correct figures into the other 3 columns i.e If I have $20.00 in the Fortnite column, divide this by 2 to get the weekly figure, multiply the fortnite figure by 26 and divide by 12 to get the monthly figure and so on. I've tried using all sorts of formulas and lots of "if" and "then" statements but ended up with a mess.
I want to be able to put an amount into any of the 4 columns and have the other 3 calculated out and filled in.
I'm sure that somebody a lot more clever than me has already done this..
Can any body point me in the right direction.
Cheers and thanks for reading...