Thread: Percentage code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark mark is offline
external usenet poster
 
Posts: 196
Default 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