Thread: formula needed
View Single Post
  #1   Report Post  
Carmellajade Carmellajade is offline
Junior Member
 
Posts: 2
Default formula needed

I am very new to using Ms Excel 2010 and am hoping that you dont mind me asking what is probably a very easy question regarding a formula.

I have 3 columns showing

Total Amount (D) (E) VAT (F) Net Amount (H)
£100.05 £14.90 £85.15


I want the H column to show the VAT rate that was used for example on the above figure it would show 17.50%

I have tried =E4/F4 but this is not showing 17.50%

HELP!!