LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula to copy/paste formula needed please. colwyn Excel Discussion (Misc queries) 4 October 22nd 08 11:27 PM
Formula needed judgejulz Excel Discussion (Misc queries) 4 February 19th 07 03:34 PM
Formula needed. Beertje Excel Discussion (Misc queries) 7 November 29th 05 09:54 AM
Formula needed Admiral70 Excel Worksheet Functions 4 August 18th 05 09:58 PM
Formula Needed! Roman Excel Discussion (Misc queries) 2 June 19th 05 09:29 PM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"