Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the decimal point. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Move the decimal two spaces to the left:
$100*.0816, for example, equals $100 * 8.16% Dave -- Brevity is the soul of wit. "Snoozie" wrote: To you pros out there this may sound stupid. If taxes are 8.160% what formula would I use to get the exact amount. Not sure where to put the decimal point. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
This will give you the amount of tax to be applied to an amount in A1.
=A1*0.0816 This will give you the total amount including tax. =A1+(A1*0.0816 ) HTH, Paul "Snoozie" wrote in message ... To you pros out there this may sound stupid. If taxes are 8.160% what formula would I use to get the exact amount. Not sure where to put the decimal point. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
"PCLIVE" wrote in message
... This will give you the total amount including tax. =A1+(A1*0.0816 ) or just =A1*1.0816 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "PCLIVE" wrote in message ... This will give you the amount of tax to be applied to an amount in A1. =A1*0.0816 This will give you the total amount including tax. =A1+(A1*0.0816 ) HTH, Paul "Snoozie" wrote in message ... To you pros out there this may sound stupid. If taxes are 8.160% what formula would I use to get the exact amount. Not sure where to put the decimal point. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
No brainer to calculate the *tax*:
=100*8.16% -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Snoozie" wrote in message ... To you pros out there this may sound stupid. If taxes are 8.160% what formula would I use to get the exact amount. Not sure where to put the decimal point. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |