Budget Spread methods

D

Doug

I have a template that I use for budgeting expenses. Some expenses are spread
using a simple straightline method or based on the number of days in a month.
Some expenses are spread based on the percentage of the months sales to total
sales or as a % of those revenues. I am currently using a table that has the
methods/values by month and I reference the table using the index function
embedded within a conditional
[=IF($X22="",0,IF(AND($Q22="Variable",$X22>2),INDEX(tble,$X22,AA$2)*$R22,IF($X22>2,INDEX(tble,$X22,AA$2)/INDEX(tble,$X22,13)*$T22)))].
In this formula tble is the table of values

Does anyone have any thoughts on how to accomplish this using an array
formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get around 30 argument limit of SUM function? 4
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
determine a range using a formula 2
Multiple Spreadsheet,Not sure what to use? Vlookup works for first 5
Spread Project Costs Over Months Using Bell Curve 2
Formula to subtotal monthly expense 5
Extracting data/using COUNTIFS 2
MS Project. Real progress of the project, % complete 1

Top