LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 577
Default Calculation Question

I have to calculate total tax based on a graduated scale. Let's say I make
$15,000 (in cell A1) and I want to calculate tax in one cell (in cell B1).
The tax rate is such that the first $1,000 is at 0%, the next $2,000 at 10%,
the next $3,000 at 20%, and then anything higher than $6,000 at 25%.

What would the formula look like in cell B1 to calculate the tax expense of
$3,050.

Thanks,
Scott

 
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
Calculation Question Mary C[_3_] Excel Discussion (Misc queries) 4 May 2nd 08 08:24 PM
Calculation question Schorn Excel Discussion (Misc queries) 11 July 22nd 07 04:11 PM
Calculation Question RJ Swain Excel Worksheet Functions 5 November 22nd 06 12:02 AM
Is there a way to...(calculation question) Jambruins Excel Discussion (Misc queries) 3 April 25th 05 02:04 PM
Calculation question Bryan Excel Discussion (Misc queries) 5 March 16th 05 04:24 PM


All times are GMT +1. The time now is 03:55 PM.

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"