Sherri,

You don't say what happens outside of the figures you gave but try:

=IF(AND(A11088,A1<=1716),(A1-1089)*4%+17.6,IF(AND(A1=460,A1<=1088),(A1-460
)*2%+4.6,"Outside Range"))


HTH

Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Sherri" <Sherri @discussions.microsoft.com wrote in message
...
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.