Excel: Hi All, Trying to get a formaula to calculate multiple calculations


I currently have the following =SUM(IF(Q35="y1","2","0")) which works fine but the problem is I need to do the same with all of the following - If Y2 then +4 If Y3 then +6 If Y4 then +8 And just to make it that little bit more difficult I then need If N1 then -2 and so on. Is this possible or am I living in a dream? :confused:


This question generated 19 answers. To proceed to the answers, click here.

This thread is current as of December 12, 2014.


For more resources for Microsoft Excel