I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from the bill into one cell in a row, and have excel workout the amount for all the other intervals (four other cells in the row).
I known how to write formulas into a cell so that the another cell in the row will populate correctly (=sum(B3/52) but don't know how to use 'or' so that the formula knows to look in one of four other cells to find a value to use... would it take VBA to do that?
Id post an example.. but I need a ranking here to do that. Column headings are intervals i.e. Weekly, Monthly, Quarterly, Annually
Im using excel 2010.
Thanks for any Help !