Can someone help me figure out the formula for Ca. State Tax for my spreadsheet?


IF over $0 but not over $7124.00 =$0
IF over $7124.00 but not over $16,890 = $78.36

I would need to divide that $78.36 by 24 to get the bi weekly paid in amount.

Thank you.