Whoops, forgot the third argument

=IF(A<460,"Below Range",IF(A<=1088,A*2%-4.6,IF(A<=1716,A*4%-26.36,"Above
Range"))

But I think you'll find the technique at my link easier to maintain,
especially if you use tables instead of hardcoding the rates.


In article ,
JE McGimpsey wrote:

One way:


=IF(A<460,"Below Range",IF(A<=1088,A*2%-4.6,A*4%-26.36))

A different, somewhat more flexible approach:

http://www.mcgimpsey.com/excel/variablerate.html



In article ,
Sherri <Sherri @discussions.microsoft.com wrote:

I'm having trouble writing what I think is a nested formula :

If A is =460 and A is <=1088 Then this formula should be used:
(A-460)*2%+4.60

If A is =1089 and A is <=1716 Then this formula should be used
(A-1088)*4%+17.16

I want the response returned to one cell. This formula is to calculate CA
state taxes.