Thread: Percentage code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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



.