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

[Ricardo <email @ redacted>]

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