LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Formula that takes a range of values into consideration

In cell D5 i have a figure that can varry in cell G5 i need a formula that
will do calculations depending on a range of values.

first $37,106 20.05%
over $37,106 up to $40,970 24.15%
over $40,970 up to $65,345 31.15%
over $65,345 up to $74,214 32.98%
over $74,214 up to $76,986 35.39%
over $76,986 up to $81,941 39.41%
over $81,941 up to $127,021 43.41%
over $127,021 46.41%


--
A.
 
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
Calculating Months while taking into consideration days Excel Trouble[_2_] Excel Worksheet Functions 3 February 8th 08 05:57 PM
IF formula using a range of values in a cell Baz Excel Worksheet Functions 7 January 25th 08 03:08 PM
How to define range of values in a formula? yasen Excel Worksheet Functions 2 May 8th 07 07:58 AM
formula for range values question webadict2be Excel Discussion (Misc queries) 4 February 7th 06 12:49 AM
MSOffice Excel 2003-Validation Listbox takes only 47 values Keryun Excel Worksheet Functions 4 February 2nd 06 06:02 PM


All times are GMT +1. The time now is 06:01 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"