This is the formula applied to my spreadsheet..
=IF(AND(K8="X",L8=2),4.5,0)+IF(AND(K8="X",L8=1),1,0)+IF(AND(K8="X",L8=3),9,0)+IF(AND(K8="X",L8=4),18 ,0)+IF(AND(K8="X",L8=5),36,0)
For some reason it does not matter what is selected for K8, it seems to only be taking into consideration L8.
How can I fix this?
Bookmarks