On Sun, 19 Feb 2006 10:59:58 -0600, Rod Engelsman wrote: > 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=.......
Ahh. Ok, thanks. Hadn't thought of that. A case select command would be nice, but this should do what I need. Thanks, Paul -- Using OOo 2.0 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
