[Previous Months][Date Index][Thread Index][Join - Register][Login] Help@Insulin-Pumpers.org [Message Prev][Message Next][Thread Prev][Thread Next] for subscribe/unsubscribe assistance

# [IP] Excel spread sheet - can you use IF statements?

```Sue Wrote:
I'm trying to update the excel spread sheet that I use to calculate
my boluses. Can you do an IF statement.

For example, "If B2<100 then B3=6  OR if B2> 120 then B3 = 5"

I'm trying to use my glucose value and say "If the value is greater
than 100 than take so many units of insulin (providing I figured in
how to calculate the number of nits)

and

I figured out that an if statement can be used but I just CAN'T
figure out the syntax of the statement. How do you form the test

Ricardo Responds:
Standard IF syntax is: IF(logical_test,value_if_true,value_if_false).

Two IF statements can be combined (one nested in another) to solve
your question. Try putting this formula into cell B3.

=IF(B5<100,6,IF(B5>120,5,0))

Ricardo
Dx'd 1967, Pumping since 1/14/2004 w/ Animas IR1000 and since
7/2/2004 w/ the Animas IR1200
.
----------------------------------------------------------
for HELP or to subscribe/unsubscribe/change list versions,
contact: HELP@insulin-pumpers.org

```