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!!
|