Formula to convert numerical values in Column A with LOW/MED/HIGH
Hi there, I hope someone with a big brain can help me solve this issue I'm having.
Desired Result: I'm trying to fix a formula that will automatically input the Values "LOW", "MED", or "HIGH". I would like to be able to copy the three (corrected) formulas I have into each spreadsheet I need to work with, without having to create a lookup table)
Here's my sheet on google docs (I couldn't get it to upload in smartsheet for some reason)
- In column A, I will have fields of numbers which I want to assign the values.
- Column B is where I have a calculation that's supposed to interpret column A's values into either "LOW", "MED", or "HIGH" relative to the calculated values in C3 and C4.
Problem one: All of my values in Column B are coming in as LOW or HIGH. No mid. I can't figure out how to make mid "Higher than C, but lower than D)
Here's the calculation I'm using:
Problem two: The number of rows will depend on the sheet I'm working on.
I would like the calculations In C and D to automatically take into account all of the values in Column A, without me having to scroll to the bottom, figure out the number of rows, and hand-type the number of rows into the calculation. Is there a way to do that?
Here are the calculations for C and D
Thanks in advance for your help!