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
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