Excel Formula for prices
Closed
Pet
-
Jun 8, 2009 at 10:46 AM
aquarelle Posts 7129 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2023 - Jun 8, 2009 at 03:03 PM
aquarelle Posts 7129 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2023 - Jun 8, 2009 at 03:03 PM
Related:
- Excel Formula for prices
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Kernel for excel - Download - Backup and recovery
- Formula bar in excel missing - Guide
1 response
aquarelle
Posts
7129
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2023
491
Jun 8, 2009 at 03:03 PM
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