On Sun, 2006-02-19 at 15:29 -0500, Paul_B wrote: > 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.
Have you tried using lookup tables for this kind of thing. Functions: LOOKUP, VLOOKUP etc in Help. I use them for this purpose in my own tax sheets and they work. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
