<<Retain A Value Or Number>>

  • Thread starter Thread starter Scooterdog
  • Start date Start date
S

Scooterdog

I made a spreadsheet that tells me how much insulin to take.
Usually about ever 3-4 hours, I re-check my blood sugar.
Is there a formula or function that would allow me to do
the following:

At 0800 my Sugar reading is 150. I take .4 units.
At 1200 my Sugar reading is 130. I take 0 units.
I would like the .4 number to be replaced by the
new number, which is zero.
Is this even possible?

Thank You In Advance
 
Hi:

Can you be a bit clearer? Is there a formula (mathematical relationship)
that determines how much you take? Does it depend on the time, the reading,
or both?

Regards,

Vasant.
 
Scooterdog

Why would you want to replace it?

I would lay out my sheet with three columns.

A titled Time
B titled Sugar
C titled Units

This way you can keep track of your condition and dosage. Perhaps even make a
nice chart?

NOTE: to enter the Time in a cell hit SHIFT + CRTL + ;(semi-colon).

If, on the other hand you just want to plug in a number like 130 and have the
units pop up in a cell next to it, you could use a VLOOKUP table.

In an out of the way area of your worksheet enter a column of Sugar numbers
ranging from bottom of your range(100?) to the top (200?) in the proper
increments. You be the judge of that.

In the next column enter the required units for each of these numbers.

Select these two ranges together and Insert>Define>Name. The range will be
selected in the "Refers to:" box. Just enter a name such as MyList.

Now in B1 enter this formula =VLOOKUP(A1,MyList,2,FALSE)

In A1 enter a Sugar number(130?) and see 0 pop up in B1.
If you change Sugae number in A1 to 150 .4 will pop up in B1.

Gord Dibben XL2002
 
Back
Top