Calculate commission

[pansovic]

I need to know the value under the following condition:
When price is less than 20 than apply 1%
When price is between 20 and 30 than apply 2%
When price is more than 30 than appl 3%.
What is the formula that I need to apply?

[NBVC]

=Lookup(A1,{0,20,30},{1%,2%,3%})*A1

where A1 contains the price

you might need to adjust the numbers in the first array to the actual lower bounds you desire for each percentage group

[ConneXionLost]

You may need to represent the percentages in decimal form:

Please Login or Register  to view this content.

Note ~ I only used five decimal places to identify the portion representing "over 30". You may prefer your own level of accuracy.

Cheers,

[pansovic]

I get error message marked 0,20,30. As well the , after A1 I had to change to ;

[NBVC]

Replace all the commas with ;

[pansovic]

Now get error message marked "1%"
When I change to Lookup(AZ2;{0;20;30};{0,01;0,02;0,03})*AZ2 than get #żNOMBRE? which is spanish for NAME

[NBVC]

See how it comes up when you upload this sample.. see B1 formula.