I want to know if there is a way to do all the calculation in one cell (one formula), as in SUM everything up and give the result.
=IF(AND(L2<>"",F2="Hard",(LEFT(L2,1)>RIGHT(L2,1))),10,IF(AND(L2<>"",F2="Hard"),-10/(I2-1),""))
In other words, apply this formula every time the criteria are met and then SUM everything up, all in one cell. I think it can be done but if it's too complicated then nevermind, I'm just trying to save some space and make the worksheet a bit faster.
Thanks!
Bookmarks