#### Phatmatt54

##### New member

- Joined
- Nov 30, 2013

- Messages
- 2

- Reaction score
- 0

- Points
- 0

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