Excel 2002 IF
 

I'll try to explain what I am trying to do.

I am making a spreadsheet for a sliding scale tax
column "I" contains the surtax rate which is usually 1 %
column "Q" will contain an amount less than, equal to, or greater than 5000
column "Z" will return the result
example:
"I" = 1%, Q= 4000, "Z" = 40
"I" = 1%, Q= 5000, "Z" = 50
"I" = 1%, Q= 6000, "Z" = 50

As you can see "Z" can never be more than 50 @ 1% with this formula
=IF(Q:Q<=5000,Q:Q*I:I,I:I*5000) so this part works fine.

Now what I am trying to do is this:

I want the result to show up in column "Z" if column "I" is less than or
greater than 1%
But I want the result to show up in column "AC" if column "I" is equal to 1%
The result could show up in only one column at a time

"I" = 1%, Q= 4000, "Z" = 40
"I" = 1%, Q= 5000, "Z" = 50
"I" = 1%, Q= 6000, "Z" = 50
"I" = .5%, Q= 4000, AC" = 20
"I" = .5%, Q= 5000, AC " = 25
"I" = .5%, Q= 6000, AC" = 25
"I" = 1.5%, Q= 4000, AC" = 60
"I" = 1.5%, Q= 5000, AC" = 75
"I" = 1.5%, Q= 6000, AC" = 75

Excel 2002 IF
 

I think your explanation needs a little work...

The table results are the opposite of your explanation.

--
Biff
Microsoft Excel MVP


"John" wrote in message
...

I'll try to explain what I am trying to do.

I am making a spreadsheet for a sliding scale tax
column "I" contains the surtax rate which is usually 1 %
column "Q" will contain an amount less than, equal to, or greater than
5000
column "Z" will return the result
example:
"I" = 1%, Q= 4000, "Z" = 40
"I" = 1%, Q= 5000, "Z" = 50
"I" = 1%, Q= 6000, "Z" = 50

As you can see "Z" can never be more than 50 @ 1% with this formula
=IF(Q:Q<=5000,Q:Q*I:I,I:I*5000) so this part works fine.

Now what I am trying to do is this:

I want the result to show up in column "Z" if column "I" is less than or
greater than 1%
But I want the result to show up in column "AC" if column "I" is equal to
1%
The result could show up in only one column at a time

"I" = 1%, Q= 4000, "Z" = 40
"I" = 1%, Q= 5000, "Z" = 50
"I" = 1%, Q= 6000, "Z" = 50
"I" = .5%, Q= 4000, AC" = 20
"I" = .5%, Q= 5000, AC " = 25
"I" = .5%, Q= 6000, AC" = 25
"I" = 1.5%, Q= 4000, AC" = 60
"I" = 1.5%, Q= 5000, AC" = 75
"I" = 1.5%, Q= 6000, AC" = 75