Kirsty Cretney
New Member
- Joined
- Dec 12, 2014
- Messages
- 8
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?
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?