Re: $$Excel-Macros$$ need help with nested IF AND formula

2013-12-04 Thread Dan Burfield
l the people > you can,As long as ever you can.” - John Wesley* > - > > *From:* Dan Burfield > > *To:* excel-...@googlegroups.com > *Sent:* Wednesday, December 4, 2013 10:05 AM > *Subject:* $$Excel-Macros$$ need help with nested IF AND formula > > Hi,

$$Excel-Macros$$ need help with nested IF AND formula

2013-12-04 Thread Dan Burfield
Hi, thx in advance for your help. I am trying to build a spreadsheet that will help calculate medication doses. The variables involved are weight (wt) and creatinine clearance (CrCl). Here is the decision tree: if wt(C4) is >121 and CrCl(C8) is >= 50 then Infusion = 20 if wt(C4) is >121 and Cr