Hi All,
I am setting up a worksheet for work that has variables on values. Currently, i am using the following formula:
=IF(Q4="R",Q$2,IF(P4="r",P$2,IF(O4="R",O$2,IF(N4="R",N$2,IF(M4="R",M$2,IF(L4="R",L$2,IF(K4="R",K$2,IF(J4="R",J$2,I$2))))))))
Current.PNG
However, this is limited in a couple ways that I'd like to improve.
The first issue is that the IF statement is a limited to nine sections, and three of my Panels have ten, as such, I would like to expand it to cover the full panel.
The second for improvement is that when blank, I'd like it to say < the lowest value. Therefore, if going by the attached example, if all cells are blank, it should be at a value of <0.015 in the MIC mg/L column.
The current set up has a formula for 0.3 up to 8, but if the value is 0.03 or below, it highlights red for the user to review the value and ensure it is a true 0.03, or if it is lower and require manual input.
Many Thanks
Bookmarks