I'm trying to use multiple IF statements from a series of conditions in a sheet to give an overall total but I cant get the formula (below) to work. I suspect its the way I'm trying to link the elements together as each part of the formula before and after the '+' work if used on their own. Or, the way I'm trying to get it to work out the conditions in the cells before adding them together (in this case cells D8 and M8).
=SUM(IF(AND(D8>0.31,D8<=0.5),25),IF(AND(D8>0.5,D8<=0.75),50),IF(AND(D8>0.75),100)+(IF(AND(M8>0,M8<=10),25),IF(AND(M8>10,D8<=20),50),IF(AND(M8>20),100)))
Can anyone assist?
In the attachment, I'm trying to generate a total score in Cell B8 of the Extended Dash based on the conditions in D8 and M8
Bookmarks