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