charge

  1. E

    Using INDEX MATCH MATCH to find next "possible" value in array

    I have a table that contains Limits($), Zones and the resulting charge amount. <tbody> A B C D E 1 Limit $10000 $15000 $20000 $25000 2 Zone 1 $10 $20 $30 n/a 3 Zone 2 $10 n/a n/a n/a </tbody> I have the above table. I want to pass in a zone number and a limit amount. If the...
  2. B

    Nested If Statement

    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...
  3. P

    Help With Formula

    Hello! I have a program (well, excel program) for my work. The simple formula for this is Job amount x rate (rate is found by a formula in another tab with the state and monthly rate). For example, Arkansas at 12 months is .08699. On the first page I have Job amount (enter manually)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top