$$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

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

2013-12-04 Thread Excel_Lover
It is better to attached a sample sheet. On Wed, Dec 4, 2013 at 6:05 PM, Dan Burfield wrote: > 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

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

2013-12-04 Thread Paul Schreiner
try: =IF(C4>121,IF(C8<50,10,20),    IF(C8<50,(1*C4*60)/(0.75*1000), (2*C4*60)/(0.75*1000)    )    ) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can,

$$Excel-Macros$$ Please help on FileName = Dir()

2013-12-04 Thread maksood alam
Hi Guys, Can anyone please explaint what *FileName = Dir() *is doing in below code. Public Sub RecursiveDir(ByVal CurrDir As String, Optional ByVal Level As Long) Dim Dirs() As String Dim NumDirs As Long Dim FileName As String Dim PathAndName As String Dim i As Long Dim Filesize As Double ' Mak

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

2013-12-04 Thread Dan Burfield
Thanks so much Paul, works perfectly. Happy Holidays! On Wednesday, December 4, 2013 1:39:48 PM UTC-5, Paul Schreiner wrote: > try: > =IF(C4>121,IF(C8<50,10,20), >IF(C8<50,(1*C4*60)/(0.75*1000), > (2*C4*60)/(0.75*1000) >) >) > > *

$$Excel-Macros$$ Re: Login and Logout time tracker...need help....

2013-12-04 Thread Marc Wilaby
When you get the bugs worked out I would appreciate a copy of this if you are willing. Sometimes I do consulting for clients and need a quick and easy way to track time. Thanks On Tuesday, February 19, 2013 12:09:42 PM UTC-8, Bullet wrote: > > Hi Experts, > > Need a small help from your end. I