View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default If Then condition on Values

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,