Excel Formula for prices
Closed
Pet
-
Jun 8, 2009 at 10:46 AM
aquarelle
aquarelle
- Posts
- 7099
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- January 20, 2022
Related:
- Excel Formula for prices
- @ in excel formula ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- How to ignore false in excel formula ✓ - Forum - Office Software
- Number to words in excel formula - Guide
- Excel formula to transfer data between worksheets - Guide
1 reply
aquarelle
Jun 8, 2009 at 03:03 PM
- Posts
- 7099
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- January 20, 2022
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 :
Best regards
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