ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Formula Question (https://www.excelbanter.com/excel-discussion-misc-queries/44626-excel-formula-question.html)

denise-tannersville

Excel Formula Question
 
I need to multiply the amount in Col A by a percentage Col B and get the
total amount in Col B (example: 20,000*2%) I just need TOTAL to show in Col B.

CLR

IN B1 put.....

=A1*2%

If you're looking for a 2% increase, use

=A1*1.02

Vaya con Dios,
Chuck, CABGx3



"denise-tannersville" wrote:

I need to multiply the amount in Col A by a percentage Col B and get the
total amount in Col B (example: 20,000*2%) I just need TOTAL to show in Col B.



All times are GMT +1. The time now is 03:04 PM.

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