Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula needed. | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions | |||
Formula Needed! | Excel Discussion (Misc queries) |