Nested If Statement

[barnsey11]

I have a spreadsheet that included 3 scenarios that results in a different billing charge for each scenerio dependent on the budget.

Medium Budget CPM IMP 20% buffer Fee DV DCM FT Grand Total
D $1,000,000 $6.00 166,666,667 200,000,000 - $17,000 $6,000 $20,000 $43,000
V $5,000,000 $16.00 312,500,000 375,000,000 - $54,375 $11,250 N/A $65,625
S $1,000,000 N/A N/A N/A 12,500 $12,500


D: $225000
D:$150,000
V: $120,000
D:$500,000
S: $700,000
V: 100,000
S:400,500

Is there a formula that can string together the formulas in the top table to give me a grand total, based upon the budget input (above cost).

 

[istiasztalos]

Hi,

Please paste data in table format, and explain a bit what the rows mean (and columns if that's relevant), maybe it's just because it's Friday afternoon, but I have literally no clue what that pile of numbers is supposed to mean

What formulas are you trying to string together?

Thanks!