| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Percentage code
I am using Excel 97.
I want to calculate a Tax amount which is a percentage of a value, but I am struggling. I can't get the correct value!! If I use a normal calculator 10 / 17.5 = 0.57142...... whereas 10 / 17.5% = 1.75 How do you do perecentages in VBA? Can anyone help please? Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Percentage code
Hi
try msgbox amount*0.175 -----Original Message----- I am using Excel 97. I want to calculate a Tax amount which is a percentage of a value, but I am struggling. I can't get the correct value!! If I use a normal calculator 10 / 17.5 = 0.57142...... whereas 10 / 17.5% = 1.75 How do you do perecentages in VBA? Can anyone help please? Mark . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Percentage code
are yoU serious?
VALUE * 17.5 / 100 -----Original Message----- I am using Excel 97. I want to calculate a Tax amount which is a percentage of a value, but I am struggling. I can't get the correct value!! If I use a normal calculator 10 / 17.5 = 0.57142...... whereas 10 / 17.5% = 1.75 How do you do perecentages in VBA? Can anyone help please? Mark . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| custom function-code for percentage | Excel Discussion (Misc queries) | |||
Linear Mode
