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 -- Using OOo 2.0 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
