Previous Topic Next Topic

Excel Formula for prices

Closed
Pet - Jun 8, 2009 at 10:46 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Jun 8, 2009 at 03:03 PM
Hello,

I really don't know how to create formula for my task:

Item bouth for Total price £535,000 (comission + price)

How much is the Price only?


Condition: Up to £25,000………………..….25%

From £25,000 - £500,000……..20%

Above £500,000………………...12%

I have managed to calculate commision from the price, but cannot do it in return function.

I have tried everything, but this is too advance for me. Please, please help. Thank you very much,

Petra
Related:

1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jun 8, 2009 at 03:03 PM
Hello,
I supposed that you put your price in the column A and that the first row contains the titles "Price", "Commission", you have to use the following formula and drag it down : 
	A	B
1	Price	Commission
2		=IF(A1<25,A1*25%,IF(AND(A1>=25,A1<=500),A1*20%,A1*12%))

Best regards
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response