Nested IF functions

**tigertiger** · 06-16-2009, 11:38 AM

why don't you use the short formula:

=E2+IF(B3<=32,(C3="x")*D3/32,-12.5*(MOD(B3,2)=1))

with column B contains number of days (the same in your file) -
instead of depending on row() ?

**RyanF** · 06-16-2009, 03:10 PM

Originally Posted by tigertiger

why don't you use the short formula:

=E2+IF(B3<=32,(C3="x")*D3/32,-12.5*(MOD(B3,2)=1))

with column B contains number of days (the same in your file) -
instead of depending on row() ?

Formula works great-thanks. Only thing is it relies on the "x"value I put in, but if the dose is taken on another day, would have to alter the x value to a different day.
But it is working well-appreciate the help

**tigertiger** · 06-16-2009, 10:20 PM

Originally Posted by RyanF

Only thing is it relies on the "x"value I put in, but if the dose is taken on another day

if you want not to rely on "x", the formula will be:
=E2+IF(B3<=32,(MOD(B3,2)=1)*D3/32,-12.5*(MOD(B3,2)=1))

OR
=E2+(MOD(B3,2)=1)*IF(B3<=32,D3/32,-12.5)
with the same number of days in the two stages (1st & 2nd stage)

in the formulas, if also do not rely on the value in cplumn B - you can use Row() replace B3 appropriately

G luck.