tiered rate structure

Fullført Lagt ut 5 år siden Betales ved levering
Fullført Betales ved levering

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%

Regnskap Excel Finansiell analyse

Prosjekt-ID: #18595461

Om prosjektet

1 bud Eksternt prosjekt Aktiv 5 år siden

Tildelt til:

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 Mer

$15 USD på 0 dager
(421 omtaler)
6.9