wkirkcrawford
Board Regular
- Joined
- Dec 7, 2013
- Messages
- 72
Greetings,
I'm creating a Log of my Blood Sugar Readings.
I am checking the last time that I took a shot. Not all lunchtime do I take a shot.
Here's what I started with; =IF(AC10="","",IF(U10<>"",MOD(AA10-I10,1),MOD(AA10-R10,1))) AC10 is current reading, U10 does the VLOOKUP, results could be 2 to 7. AA10 is current time, I10 is the time I took my shot in the morning. R10 is lunchtime that I should take a shot, but sometimes I don't take a shot.
With this current Formula a blank cell, U11, results in 'VALUE'. It should check, MOD(AA11-R11,1).
I'm using a Surface RT and Office came with it.
W. Kirk Crawford
Tularosa, New Mexico
I'm creating a Log of my Blood Sugar Readings.
I am checking the last time that I took a shot. Not all lunchtime do I take a shot.
Here's what I started with; =IF(AC10="","",IF(U10<>"",MOD(AA10-I10,1),MOD(AA10-R10,1))) AC10 is current reading, U10 does the VLOOKUP, results could be 2 to 7. AA10 is current time, I10 is the time I took my shot in the morning. R10 is lunchtime that I should take a shot, but sometimes I don't take a shot.
With this current Formula a blank cell, U11, results in 'VALUE'. It should check, MOD(AA11-R11,1).
I'm using a Surface RT and Office came with it.
W. Kirk Crawford
Tularosa, New Mexico