| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Complex formula
On Sun, 16 Oct 2005 20:12:03 -0700, "Marc"
wrote: Hi ! My name is Marc and I am a medical resident in Canada. I use MS Excel 2003. I would need your help in order to find or "set up a calculation strategy" in Excel. When a child has lost lots of fluids (e.g by vomiting), I need to give him some intravenous fluids. I need to calculate this amount of fluids based on the child's weight. In clinic, the formula is : - For the first 10 kg, it is 100 mL/kg - For every kg between 10 and 20 kg (included), it is 50 mL/kg - For every kg above 20 kg, it is 20 mL/kg) For example, The child is 9 kg : 9 kg * 100 mL/kg = 900 mL The child is 16 kg : (10 kg * 100 mL/kg) + (6 kg * 50 mL/kg) =1300 mL The child is 34 kg : (10 kg * 100 mL/kg) + (10 kg * 50 mL/kg) + (14 kg * 20 mL/kg) = 1780 mL Would you have any suggestion for a formula to calculate the IV fluids only by entering the child's weight in Excel. Thank you for your help ! Marc A. Allard, MD, MSc Please, send your suggestions to This is a common type of problem. Although more often seen with tax tables than rehydration calculations <smile. I would set up a table with three columns showing your "base fluid amt" and incremental amount for each of the weight breaks: Wt Base Incremental 0 0 100 10 1000 50 20 1500 20 Select the range and NAME it "tbl" (Insert/Name/Define:) I would then use the following formula: =VLOOKUP(A1,tbl,2)+VLOOKUP(A1,tbl,3)*(A1-VLOOKUP(A1,tbl,1)) with the child's weight in A1, this will give you the fluid requirement. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide formula | Excel Worksheet Functions | |||
| Complex =mid formula | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
