Hi, my name is Henry. I am working with the excel to analyse my data for psychological experiment. I have to code 4 condition. 0=both masculinity score and femininity score lower than median 1=masculinity score over median but feminity score lower than median, and it is male 2= masculinity score lower than median but femininity score over median, and it is female 3=both score over median I tried to make the "nested IF function" but it said error after I made this formula: =IF((AX>=2.727272,AY>=3.117646),"3", IF((AU=1,AX>=2.727272,AY<3.117647),"1", IF((AU=2,AX<2.727272,AY>=3.117647),"2","0"))) I dont get why it is wrong, thanks!
Solved by C. S. in 25 mins