ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   set a formula to get a percentage of another field (https://www.excelbanter.com/excel-discussion-misc-queries/157043-set-formula-get-percentage-another-field.html)

Gary__69

set a formula to get a percentage of another field
 
I am trying to get a formula for excel database, I would like to know how to
get a field to show me 11% of another field.....example 11% of $500.00 dolars
is $55.00 dollars, Gross, percentage & Net, could someone help as I am going
nuts trying to sort this out......Thankyou

Mike H

set a formula to get a percentage of another field
 
Perhaps:-
A1= $500

B1 =A1*.11

or

=A1/100*11

Mike

"Gary__69" wrote:

I am trying to get a formula for excel database, I would like to know how to
get a field to show me 11% of another field.....example 11% of $500.00 dolars
is $55.00 dollars, Gross, percentage & Net, could someone help as I am going
nuts trying to sort this out......Thankyou


David Biddulph[_2_]

set a formula to get a percentage of another field
 
.... or may be clearer as =A1*11%
--
David Biddulph

"Mike H" wrote in message
...
Perhaps:-
A1= $500

B1 =A1*.11

or

=A1/100*11


"Gary__69" wrote:

I am trying to get a formula for excel database, I would like to know how
to
get a field to show me 11% of another field.....example 11% of $500.00
dolars
is $55.00 dollars, Gross, percentage & Net, could someone help as I am
going
nuts trying to sort this out......Thankyou





All times are GMT +1. The time now is 12:56 PM.

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