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]
