Sorry if this insults anyone, but...
I want excel to calculate taxes based on salary so in
column A is the one value
column B another value
column C the tax amount
Tax amt is C when salary is >= A and <= B
For example, salary = $235.97
Column A (minimum) Column B (maximum) Column C (tax amt)
220--------------------------230--------------------------3.79
230--------------------------240--------------------------4.16
240--------------------------245--------------------------4.54
Formula should produce $4.16
Can someone help me?
I want excel to calculate taxes based on salary so in
column A is the one value
column B another value
column C the tax amount
Tax amt is C when salary is >= A and <= B
For example, salary = $235.97
Column A (minimum) Column B (maximum) Column C (tax amt)
220--------------------------230--------------------------3.79
230--------------------------240--------------------------4.16
240--------------------------245--------------------------4.54
Formula should produce $4.16
Can someone help me?