Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2020, 02:57 PM
jaygb jaygb is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2019
Posts: 3
jaygb is on a distinguished road
Default formula for calculating tax isn’t working


I tried entering this formula but it didn’t calculate the 10% tax of the €169990.00 for me https://i.imgur.com/QQtfjmk.png it says “!F5 is not in table” https://i.imgur.com/hcj2goX.png

can you tell me how i'd make it so that the area to the right of "total tax" will automatically fill in with 10% of the subtotal?
Attached Files
File Type: docx Invoice-Template-doc.docx (34.4 KB, 4 views)
Reply With Quote
  #2  
Old 11-10-2020, 05:37 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: cant make formula for calculating tax
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-10-2020, 06:07 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To see how to do this and a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/word/...-tutorial.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for calculating dates based on Business Days jthomas666 Excel 2 03-02-2020 09:05 AM
If & And formula not working Haha88 Excel 3 02-17-2019 05:57 AM
A formula to create a sliding scale for calculating markup percentages against product cost. dannylenco Excel 2 12-29-2017 07:35 AM
Formula for calculating total when number and letter in one cell Oleg Excel 5 02-22-2017 03:05 AM
MS Excel Investing Formula for calculating stock return HELP pls doug6388 Excel 0 09-05-2014 08:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft