+ Reply to Thread
Results 1 to 6 of 6

I need to create a conditional paragraph based on the value of a cell...

  1. #1
    Registered User
    Join Date
    10-21-2013
    Location
    Independence, MO
    MS-Off Ver
    Excel 2013
    Posts
    4

    I need to create a conditional paragraph based on the value of a cell...

    First, thank you for your assistance. Second, here is my dilemma:

    I am a physician attempting to create a form that will assist in quickly interpreting laboratory data. While we receive laboratory results listing whether test results are within "laboratory normal" values, laboratory normals are different from "homeostatic normal" values. In other words, just because something is not pathologically abnormal, that doesn't mean that those results are homeostatically optimum. Therefore, I wanted to build a sheet that would allow me to enter laboratory results and automatically return findings of "high" or "low" based on homeostatic values.

    I have successfully constructed page one which lists all of the common laboratory tests that are performed, and returns a value of "high" or "low" in the last column based on the values entered in another column of patient test results.

    What I am struggling with is page two. I would like, beginning on page two, to have this form return results in paragraph form based on the values determined in the "high vs. low" column. In other words, if the value is "high," I would like page two to read like this:
    High Test Name
    Common causes of this are:
    1) Cause #1
    2) Cause #2
    3) Cause #3

    Common treatments for this are:
    1) Treatment #1
    2) Treatment #2
    3) Treatment #3
    Conversely, if the test result is "low," the paragraph returned would be different.

    If the test result is blank, then nothing is returned.

    Is there a way to do this? And, when the results are returned, I would like them to be one after the other on the page as opposed to one section of results followed by a big blank space where negative value cells are located and then the next positive test result. Obviously, it would fall to the physician to interpret the multiple findings contained within the report to deduce what is the most likely cause of the underlying data, but this could go a long way towards accumulating the data in one place to point the physician in the right direction.

    I apologize if similar issues have been discussed before. I've tried to search the forum, but am not finding a similar scenario that solves my problem.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,849

    Re: I need to create a conditional paragraph based on the value of a cell...

    Yes, it could be done, but you need to supply a sample workbook so we can see how your data is laid out and how best to report it. The FAQ describes how to attach a file to your post.

    Pete

  3. #3
    Registered User
    Join Date
    10-21-2013
    Location
    Independence, MO
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: I need to create a conditional paragraph based on the value of a cell...

    Thanks for responding. I didn't find an exact link for what you're requesting but think I can figure out how to post what I've got so far. Here is the document I've created to this point: I've attached the file I've created to date. The information that will be inserted as the conditional information is proprietary data which I do not have permission to post here, but suffice it to say the data will be in the format of:
    If Test Name is "High,"
    Common Causes of This Are:
    1) Cause #1
    2) Cause #2
    3) Cause #3

    Common Treatments for this are:
    1) Treatment #1
    2) Treatment #2
    3) Treatment #3
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-21-2013
    Location
    Independence, MO
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: I need to create a conditional paragraph based on the value of a cell...

    Any ideas from anyone?

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,849

    Re: I need to create a conditional paragraph based on the value of a cell...

    In your first post you said:

    If the test result is blank, then nothing is returned.
    and the file you posted has no sample test results in it so we can't work on it. Please supply some example results and then in another sheet show how you would like that set of results to be displayed.

    Pete

    EDIT: Also, where are we likely to get the common causes and common treatments from ?

  6. #6
    Registered User
    Join Date
    10-21-2013
    Location
    Independence, MO
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: I need to create a conditional paragraph based on the value of a cell...

    Pete, I apologize for misunderstanding what you were looking for. So, in this first excel file, I've plugged in a few sample numbers that are representative of a BMP and a CBC w/diff. I've also attached a "Word" file that is indicative of the type of output I'm looking for. This is primarily for the in-house brief overview of test results to point the doc in possible directions... Therefore, it doesn't have to be a pretty report produced in Word. I don't care if it spits it out in Word or is just autogenerated within the same Excel file. After plugging in the test results, I plan to print out the report and then discard the entries... leaving the original excel file unaltered and ready to use on the next patient report.

    In my example, you'll see that Sodium and Potassium are low, therefore the information for consideration when either of these are low is presented. These are then immediately followed by the information pertinent when RBCs are low... which is half way down the page as the next value out of normal limits. Then Hemoglobin, because it's the next abnormal value, etc.

    As for where I'm getting the info that is pertinent whether a value is high or low... I have multiple books, notes from seminars, etc. that I am gleaning the information from. I realize this going to take me some time to enter everything and build. I just can't figure out how to structure it so that it produces the report I need. Thank you so much for you help. If you need any further clarification, please don't hesitate to ask.

    - Doc G
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Concatenating cell into a paragraph
    By Aren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2013, 06:48 PM
  2. Using a macro to create a conditional format based on a date in a cell
    By srsev in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2012, 04:39 PM
  3. use vbasic to create icon conditional formating based on other cell values?
    By flyboy54 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2012, 02:56 PM
  4. Create new set of numbers based on conditional rules
    By promo786 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-27-2011, 04:25 AM
  5. [SOLVED] Starting a new paragraph within a cell
    By Kath firman in forum Excel General
    Replies: 2
    Last Post: 01-05-2006, 11:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1