Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2019, 05:37 PM
Steve_R Steve_R is offline Better formula to compute Tax from Compensation other than nested IFs Windows 7 64bit Better formula to compute Tax from Compensation other than nested IFs Office 2010
Novice
 
Join Date: Dec 2019
Posts: 6
Steve_R is on a distinguished road
Default

Incorporate Vlookup(). The link below explains it well


Tax Rates in Excel - Easy Excel Tutorial
Reply With Quote
  #2  
Old 12-17-2019, 03:26 PM
Marcia's Avatar
Marcia Marcia is offline Better formula to compute Tax from Compensation other than nested IFs Windows 7 32bit Better formula to compute Tax from Compensation other than nested IFs Office 2013
Expert
Better formula to compute Tax from Compensation other than nested IFs
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by Steve_R View Post
Incorporate Vlookup(). The link below explains it well
Thank you Steve. Vlookup would have been simpler to use but for the presence of the plus 30000, 140000 if taxable income is... in the formula.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Better formula to compute Tax from Compensation other than nested IFs vlookup nested formula paxon Excel 1 09-14-2018 12:09 AM
nested IF formula question H28Sailor Excel 5 05-12-2017 11:01 PM
Better formula to compute Tax from Compensation other than nested IFs Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date mshu31 Word 1 02-09-2017 02:04 PM
Better formula to compute Tax from Compensation other than nested IFs Compute Time-Weighted Investment Return billbowers Excel 1 06-23-2016 08:30 AM
nested formula using IF & AND paxon Excel 3 02-18-2016 05:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:41 PM.


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