Percentage code

[Mark]

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

 

[Frank Kabel]

Hi
try
msgbox amount*0.175

 

[Patrick Molloy]

are yoU serious?

VALUE * 17.5 / 100