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

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
--
If this has helped you, please click Yes

Thanks,
Megan


"malik" wrote:

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

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??



malik wrote:
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

--
Matt Lynn

Message posted via http://www.officekb.com

value times .3

malik wrote:

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