nested IF formula with multiple conditions based on 2 columns

nested IF formula with multiple conditions based on 2 columns
this is a blood glucose sheet i am working on the values are copy pasted into a excel sheet from a csv file the meter or meter program makes.

in column D is the blood glucose reading example ( no.s ranging from the 60's to maybe 500 ) (70 to 110 before a meal and 90 to 140 after a meal is the ideal range)

column K is a code 7 = Before Meal and 9 = After Meal or blank when info is put in from older meter or outside sources
column S is where i want the results to appear for conditional format and color code reasons so in order to work right the values in column S need to change as to weather Column K is blank has a 7 or a 9 as to how it figures if a no. in Column D is within target range or not


this formula in column S now -> =IF(AND(D13>=1, D13<=69), "Low", "") & IF(AND(D13>=70, D13<=110), "Good", "") & IF(AND(D13>=111, D13<=130), "High Moderate", "") & IF(AND(D13>=131, D13<=150), "High", "") & IF(AND(D13>=151), "Bad", "")

would work for a before meal reading if it would look into column K and put these results out if there was a 7 there . if there was 9 the range would have to change a little bit and if it were blank might just change the word in column s to know it is just not as accurate reading
i hope i am making a little bit of sense if i can get it do just do something in (S) based on 7 or 9 in (K) with a few ranges simular to above formula i think i can figure it out i seam to be stuck
thanks in advance for any help or pointers

Thank you for helping but i do not understand how this formula works to modify anything i modified your sheet with the pages i am trying to fix and maybe it will help the input sheet is the sheet where everything gets copied from the csv file and the blood glucose sheet is more for looking at a cleaner look is what i was trying to make it to be i guess i am asking is there any other way ?

thank you so much for your effort and time i will see if i can figure it out i may have to try to change up the ( K12="","Inaccurate reading" ) part nothing on what you have done if anything it me not knowing what to do with it what it. hopefully will end up with is the readings that end up yellow mean danger low and low is more dangerous than being high well till it gets way high its just low can sneak up on a person and is caused by the medications or exorcise / work and the highs usually come from what one eats and is usually that persons fault and what not. but any ways hoping to get the colors in D all controlled by what the input copied from the csv file from the meter program to be more accurate when there is info coming from the program as to weather a person has just had a meal in 2 hrs or not which if they have makes sugars higher or should pending what they ate lol any ways it will prob take a bit to dig into it here and thank you so much again