tiered rate structure

Tamamlanmış İlan edilme: 5 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

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%

Muhasebe Excel Mali Analiz

Proje NO: #18595461

Proje hakkında

1 teklif Uzak proje Aktif 5 yıl önce

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 15%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(421 Değerlendirme)
6.9