View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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