Hey all, got a question for our Excel and GoogleDocs gurus out there.
I need to achieve the following in a GoogleDocs worksheet:
1. Take the value from a specific cell.
2. Compare it to a range fo values across a horizontal row of cells.
3. Confirm which number specified the original value is closest to.
4. Return a code from a separate horizontal row of cells that indicates which specified range index the original number was correlated to.
I'll be the first to admit I'm a bit of an Excel noob, so I apologise if this is basic - I'm badly dyslexic and I just can't quite wrap my head around how to get these four steps to happen in one move.
I've attempted to dad the workbook itself, but in the interest of quick clarity, here's a screenshot with the values I need to work with in red.
Nay help greatly appreciated!
PDO question.PNG
LiamHH
Bookmarks