tiered rate structure

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

HELLO:

I need an IF function I believe that will calculate a rate based on a tiered balance. Based on the information below.

Money Market

$100 - $2,499.99 0.000%

$2,500 - $9,999.99 0.400%

$10,000 - $24,999.99 0.450%

$25,000 - $49,999.99 0.500%

$50,000 - $89,999.99 0.550%

$90,000 - $249,999.99 0.650%

$250,000 - $349,999 1.140%

$350,000 & Above 1.288%

Accounting Excel Financial Analysis

Project ID: #18595461

About the project

1 proposal Remote project Active 5 years ago

Awarded to:

MimiFL

Hi, yes this can be achieved with nested if statement. If you are interested in working with me, feel free to message me and i will try to help immediately. I've done many If formula based projects without a single pro More

$15 USD in 0 days
(421 Reviews)
6.9