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

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



.

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



.