Multiple variable IF function - Help

[Nick312]

1) G33 x C45 PLUS
2) If H33 is $1M more than G33, take the $1M and multiply by C46 PLUS
3) IF H33 is $2M or more than G33, for every million starting at $2M and above, take that Million difference and multiply by C47.

How can I write this so definitively? Can I do this in one spot or do I need to break it out?

Appreciate the help.

[modytrane]

Let's say H33 is $6.57M and G33 is $1.86M.

What do you want the result to be? explain the logic.

Attach a sample file with some data and enter results manually calculated.

[Nick312]

Trying to fill the green cells (doctored doc with exact format) with potential "Commissions".

So basically it's G33*C45 baseline + if the variance of G33 & H33 is greater than 1,000,000 multiply the first million by C46 and any additional millions by C47 to get a total sum.

[Nick312]

solved with

=SUM(G33*$C$45)+IF(SUM(H33-G33)>1000000,1000000,0)*$C$46+IF(SUM(H33-G33)>1000000,SUM(H33-G33)-1000000,0)*$C$47