Conditional calculation, how it can be done ?

Hi,

I want to calculate % of certain values. e.g if sales are below 30,000 then NIL. If sales are above 30,000 but <= 60,000 then 2 % of the sales over and above 30,000. If sales are above 60,000 then 1.50 % of 60,000 & anything above 60,000 will be 2 %. Does this example need if/ and if function ? If so how is it put ; if not which else is the one I can use .

Regards,

Vikrant

Try...

=IF(A1<30000,"Nil",IF(A1<=60000,(A1-30000)*2%,(60000*1.5%)+(A1-60000)*2%))


If you're using a non-English version of Excel that uses a semi-colon as a list separator, try...

=IF(A1<30000;"Nil";IF(A1<=60000;(A1-30000)*2%;(60000*1.5%)+(A1-60000)*2%))

Hope this helps!

Hi Domenic

Thx. I tried the condition that you mentioned. But it is giving formula error. Any other way ?

regards, vikrant

Hi,

I am sorry. I did a mistake. It is working. Thanks for your help

Regards,

Vikrant