Can you confirm please what answer should be returned if A < 460 or if A
1716


--
Return email address is not as DEEP as it appears
"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.