Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Guru's:
I have a situation in two columns "A4" & "B4". in column "A4" & "B4" I need to calulate percentages as follows, it's kinda like a TAX table where column "H" would be a single person (one Income) and column "I" would be a married couple (both working/two incomes). Thix may give you a better idea of the structure I'm looking for! 1.) If the values in column "A4" are between 12,000 and 13,360 take 0% of value, however, if the values in column "B4" is between 12,000 and 13,360, take 3,12%. 2.) If the values in column "A5" are between 13,360 and 14,660 take 2.6% of value, however, if the values in column "B5" is between 13,360 and 14,660 , take 3,64%. 3.) If the values in column "A6" are between 14,660 and 16,010 take 3.12% of value, however, if the values in column "B6" is between 14,660 and 16,010 , take 4.16%. I guess columns "A", "B", "H" & "I" would a table list of values on a another hidden page/sheet which can/would be updatable. But I need the code to look up and down each row and column, then do a calculation against cell values in column "AN" and show the results in the cell on the right in column "AM" Example of column lay-out: A B H I 12,000 13,360 0% 3.12% 13,360 14,660 2.60% 3.64% 14,660 16,010 3.12% 4.16% 16,010 17,340 4.16% 4.68% 17,340 19,990 4.16% 5,20% I hope that this is not too much and/or confusing. If there are questions, please, post them here! I am open for suggestions on the best approach on this as well! Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional sum, when condition has multiple values | Excel Worksheet Functions | |||
How to add cell values until a condition changes | Excel Worksheet Functions | |||
SUM OF NUM VALUES WITH CONDITION | Excel Discussion (Misc queries) | |||
Counting Values on a condition | Excel Worksheet Functions | |||
Cannot sum values based on condition | Excel Worksheet Functions |