Calculating percentage from one column

Solved/Closed

Judy - Jun 17, 2010 at 02:03 PM
Judy - Jun 17, 2010 at 09:10 PM

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

Calculating percentage from one column
Percentage formula in excel marksheet - Guide
How to delete column in word - Guide
Display two columns in data validation list but return only one - Guide
Tweetdeck expand column - Guide
Excel count occurrences of string in column - Guide

1 response

Answer 1 / 1

Netscur Posts 21 Registration date Thursday July 23, 2009 Status Member Last seen April 6, 2012
Jun 17, 2010 at 02:15 PM

Do you have a maximum range (end column)?

=SUM(C8:C1000)*0.1

Judy
Jun 17, 2010 at 02:49 PM

This is not working. I am sorry that I cant explain it right.
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.........

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2010 at 05:32 PM

Have you tried in D8

= C8 * 0.1
Just enter that in D8 and then drag it down to last row of your data

Judy
Jun 17, 2010 at 09:10 PM

THANK YOU

Similar discussions

HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS

Percentage calculation

Excel Formula

VBA find column by name and sort

Percentage Work

Similar discussions

Subscribe To Our Newsletter!