ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   percentage formula (https://www.excelbanter.com/excel-discussion-misc-queries/246237-percentage-formula.html)

Malik

percentage formula
 
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

Megan

percentage formula
 
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


Mattlynn via OfficeKB.com

percentage formula
 
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


Bob I

percentage formula
 
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




All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com