On Mon, 20 Feb 2006 09:31:28 +1100, Ross Johnson wrote: > 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.
That indeed looks like it would do it, as it amounts to a powerful case select statement. Should be interesting working out the details. Will get on this maybe tomorrow. Thanks much, Paul -- Using OOo 2.0 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
