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
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
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,
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
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)
>)
>)
>
> *
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