percentage formula

M

malik

i have to calculate the 30% of some amount in the following formate
col1 col2 col3
amount 30% total
waiting for urgent response from you people
thanks alot
 
M

Megan

Let's say your data is in the following cells:

a2, b2, c2

In cell b2, enter =a2*.30.
In cell c2, enter =a2+b2
 
M

Mattlynn via OfficeKB.com

assuming your amount is in cell a2, then in cell b2 enter the formula =(a1*0.
30) to get 30% of the amount.
Not quite sure what the total column would be for??
 
Top