I agree that nested ifs will work but if you want to have all 6 tax brackets it may get a little complicated. Don't forget that the brackets are different for single and married. What I would do would be to place the bracket values for single, married, and the percentages in a table on another sheet so they can be easily changed. In your computations figure what the tax would be for each bracket and then add the 6 brackets together. I do the payroll using a Works database which is actually much like a spreadsheet and it works great using this method.
-- Dennis Disclaimer: The above is my opinion. I do not guarantee it. Be sure to back up any files involved and use at your own risk. "Rod Engelsman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Paul_B wrote: > >>Is there any way to set up a multiple case logic test? >> >>Currently I have =IF(B27="";"";B27-(14.325+(E$25-70.35)*0.28)) as >>a formula in a column of cells. It tests another column's cell, >>if it's empty the result is null, otherwise a tax approximation >>kicks in. >> >>However, I'd like to allow for a few tax brackets. To do so I'd >>need to account for the null possibility plus three other >>possible number ranges (as income increases, a different tax >>formula should be invoked). >> >>Currently I don't see how this is possible. >> >>Thanks, >>paul >> > You can use nested IF() statements. > > =IF(B27="";"";IF(B27=....... > > -- > Rod --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
