ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Percent Formula (https://www.excelbanter.com/excel-discussion-misc-queries/205909-percent-formula.html)

Kim ma

Percent Formula
 
im looking n what formula to use. this is my thing

$12,222 5% sales bonus 10% sales bonus 15% sales bonus

so i need the ormula to find 5% of 12222, 10% 12222 and so on... can any one
help plz.

Sean Timmons

Percent Formula
 
so, presumably youll have these 4 values in the sheet.

So, dollar is in A2, 5% in B2, 10% in C2, 15% in D2

in B3, =$A2*B2

Copy this across to D2

"Kim ma" wrote:

im looking n what formula to use. this is my thing

$12,222 5% sales bonus 10% sales bonus 15% sales bonus

so i need the ormula to find 5% of 12222, 10% 12222 and so on... can any one
help plz.



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

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