Results 1 to 4 of 4

Thread: Blood sugar results

  1. #1

    Blood sugar results



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Acolyte rollis13's Avatar
    Join Date
    Feb 2013
    Location
    Cordenons
    Posts
    31
    Articles
    0
    Excel Version
    2016 64bit
    This should do:

    =IF(B3<=7,"",B3-7)

  3. #3
    Thanks rollis13 it worked fine
    Best regards
    Matt

  4. #4
    Acolyte rollis13's Avatar
    Join Date
    Feb 2013
    Location
    Cordenons
    Posts
    31
    Articles
    0
    Excel Version
    2016 64bit
    Glad being of some help .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •