Nested IF functions

**RyanF** · 06-16-2009, 09:19 AM

Originally Posted by NBVC

And are there still going to be inputs in columns C and D?

I've coloured the column in yellow which the expected values are. Above the yellow the if formula is calculating the values correctly, but after the yellow starts I need a formula that will reduce the value by 12.5 every second day (to correspond with the end of the life of that dose in the blood).

After day 32 there will be no more values in column c and d as there will be no more dosing with the drug. The drug will then exit the blood stream based on the life, 32 days, so each initial dose will no longer release 12.5 into the blood stream after 32 days from that dose.

**deadlyduck** · 06-16-2009, 10:00 AM

Try this in cell E2:

=IF(ROWS($D$2:D2)<=32,SUM($D$2:D2)/32,IF(MOD(ROW(),2)=1,SUM($D$2:D2)/32-((ROW()-33)/2)*12.5,E3))

Copy down as appropriate

**RyanF** · 06-16-2009, 10:29 AM

Originally Posted by deadlyduck

Try this in cell E2:

=IF(ROWS($D$2:D2)<=32,SUM($D$2:D2)/32,IF(MOD(ROW(),2)=1,SUM($D$2:D2)/32-((ROW()-33)/2)*12.5,E3))

Copy down as appropriate

Thanks-appreciate the feedback.

I'm finding that if I change the value from 400 to 500 in column D, I no longer get the correct figures.
I'm not sure how the MOD function works or the negative ROW function.

Appreciate any explanation on this.

Thanks

Ryan