if function would also work be be a nightmare and very long
like for first couple of ranges
=if(A1<=25.6,10,if(and(A1>25.6,A1<=26.1),8,(CONTINUE ADDING IN THE FALSE TILL THE END)))
if function would also work be be a nightmare and very long
like for first couple of ranges
=if(A1<=25.6,10,if(and(A1>25.6,A1<=26.1),8,(CONTINUE ADDING IN THE FALSE TILL THE END)))
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks