Nested IF functions

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