| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula & Percentage | Excel Discussion (Misc queries) | |||
| create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel | |||
| How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
| How can I calculate a percentage of a YES/NO field in a Pivot Tab | Charts and Charting in Excel | |||
| Percentage Formula | Excel Worksheet Functions | |||
Linear Mode
