Hi,



Can someone help me with this formula, please:

A customer gets a rebate once he reached a specific amount of sales:

over $200000 (and until 299999) 2%, when the customer reached $300000 then he gets a rebate of 4% back of everything over $200000.

I tried ( but I am a newbie ) :

=IF(G21>=200000,G21*0.02,IF(G21>=300000,G21*0.04))

Thanks in advance

Hi
is the 2% rebate from 200K to 300 k or from 0 to 300k ( if sale >200k) ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi ,

it is over $200000, no discounts under $200000

$200000 - 299999 2%

but if the customer reached $300000 then he gets 4% back for everything over $200000

Thanks

Perhaps =IF(A1>=300000,(A1-200000)*0.96+200000,MAX(0,A1-200000)*0.98+MIN(A1,200000))
where A1 contains the sale

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

How about:

=IF(A1<200000,"",IF((A1>=200000)*(A1<300000),0.02, 0.04)*(A1-200000))

=IF(G21>=300000,(G21-200000)*0.96+200000,MAX(0,G21-200000)*0.98+MIN(G21,200000))

This shows me Err:508

Thank you,

This formula shows me Err:509

=IF(G21<200000,"",IF((G21>=200000)*(G21<300000),0. 02, 0.04)*(G21-200000))

Don't know what you are doing.

Attached Files

quciolino.xlsx (14.9 KB, 10 views)

Which are your regional settings?
You will have to adapt the formula eventually if you use European settings

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer,

my fault, sorry. After I am back at work, your formula works just fine.

Probably my settings at home excel was different.

Thank to everybody for help

Thank you Xor