Hi, I have downloaded heaps of budget programs, non seem to be what I want.
They all want to group into types or all ask for the Monthly amount
Maybe someone here can help.
I know Excel basics, but have tried to make what I want but have failed.
I am an old bloke and having trouble with new tricks
Just need 1 Row completed and I can copy and do the rest
Column A Description
Column B Price
Column C Frequency A Drop Down Week or Month or Quarterly or Year, So User Selects this and then Column D,E and F are populated
Column D is the Sum Calculation of B x the frequency to =Week
Column E is the Sum Calculation of B x the frequency to =Monthly
Column F is the Sum Calculation of B x the frequency to =Year
So if I have a weekly Bill, I will know what it is weekly Monthly and Yearly
With a TOTAL at the bottom of each of the D,E and F Columns
Sample:
Kids Allowance $20 Per Week (So the week will say $20 (B)) (Month will be (B) $20*52 /12) (Quarter will be (B) $20*52/4) (Yearly will be (B) $20*52)
Netflix $9.99 Per Month (So the week $9.99*12/52) (Month will be $9.99) (Quarter will be $9.99*12/4) (Yearly will be $9.99*12)
Rates $478.77 per Quarter (So week will be $478.77*4 /52) (So Month will be $478.77*4 /12) (Quarter will be $478.77) (Yearly will be $478.77*4)
Car Insurance 927.10 Per Year (So week will be $927.10/52) (So Month will be $927.10 /12) (Quarter will be $927.10/4) (Yearly will be $927.10)
Thanks in advance
Bookmarks