Conditional statement

[Luigi]

Hello...my name is Luigi


My question is how do I write the formula as an example if cell A1 <=100000 multiply by 70%

If > 100001 and less than 200000 multiply by 80%


What my objective is , to compute my sales commissions for the year. If I generate up to 100000 I get 70%

At 100001 to 200,000 I get 80%

At 200001 to infinity I get 90%


i.e


first commission 50000 I get 35000 (70%)

second commission 50000 I get 35000 (70%)

third commission 20000 I get 16000 (80%)


Drives me crazy I can't figure it out


thank you

 

[SirJB7]

Hi, Luigi!

In B1 type:

=IF(A1<=100000,0.70,IF(A1<=200000,0.80,0,90))*A1

Regards!

PS: with such percentages, can I work for you?