Blood sugar results

Phatmatt54

New member
Joined
Nov 30, 2013
Messages
2
Reaction score
0
Points
0
I am wanting to construct a spread sheet for recording of blood test results and insulin dosage

In cell B3 I have a blood test value

In Cell I3 (correction dose) I am wanting a formula that if the number in cell B3 is equal to or less than 7 will inert a blank space in cell I3 I think this is =IF(B3=<7,” “)

however if the value in cell B3 is greater than 7 I want it to perform the function B3-7 I then want the product of that calculation to show in cell I3

For example:
Value of 6 in cell B3 types a blank space in cell I3
Value of 13 in cell B3 types 6 in cell I3

I don’t know how to do it and have found books either no help or incomprehensible! I believe it is called a nested IF function
 
This should do:

=IF(B3<=7,"",B3-7)
 
Glad being of some help :D.
 
Back
Top