scoring formula

[nicolastu]

I am trying to work out a formula for reverse scoring.

Generally Agree = 1 and Disagree = 2 but there are 3 items with reverse scoring Agree = 0 and Disagree = 1. I attempted the formula below. but its not working

=C3+IF(1=0,0=1,0)+G3+K3+O3+S3+W3+AA3+AE3+IF(1=0,0=1,0)+AI3+AM3+AQ3+IF(1=0,0=1,0)+AT3

[ChemistB]

Assuming your reverse scoring are in C3, AE3 and AQ3?

=IF(C3=1,0,1)+G3+K3+O3+S3+W3+AA3+IF(AE3=1,0,1)+AI3+AM3+IF(AQ3=1,0,1)+AT3

[nicolastu]

THANK YOU, that works perfectly!