Calculating percentage from one column
Solved/Closed
Hello,
I am trying to calculate the simple sales commission. I entered the sales amount starting C8 and will continue below. Starting D8, I need to get 10 % of C8 Data.
Not only for C8... C9...C10..............fore every rows
I am trying to calculate the simple sales commission. I entered the sales amount starting C8 and will continue below. Starting D8, I need to get 10 % of C8 Data.
Not only for C8... C9...C10..............fore every rows
Related:
- Calculating percentage from one column
- Percentage formula in excel marksheet - Guide
- Display two columns in data validation list but return only one - Guide
- Formula for calculating position in excel - Excel Forum
- How to delete column in word - Guide
- Vba select column by name ✓ - Excel Forum
1 response
Netscur
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
Jun 17, 2010 at 02:15 PM
Jun 17, 2010 at 02:15 PM
Do you have a maximum range (end column)?
=SUM(C8:C1000)*0.1
=SUM(C8:C1000)*0.1
Jun 17, 2010 at 02:49 PM
I have numbers entered on C8, C9, C10......................(It doesn't have maximum range).
I want to get 10% of C8, C9, C10...... goes on to D8, D9, D10.........
Jun 17, 2010 at 05:32 PM
= C8 * 0.1
Just enter that in D8 and then drag it down to last row of your data
Jun 17, 2010 at 09:10 PM