G
Guest
Hi, I use this formula in one cell to return a value, based on that of the
other cell, and it works fine (both cells are general data):
=(IF(X3="Normal Criteria",1,0))+(IF(X3="Critical
Criteria",1.5,0))+(IF(X3="Non-Critical Criteria",0.5,0))+(IF(X3="Non-Scoring
Question",0,0))+(IF(X3="Very Critical Criteria",2,0))
I then use the following formula on another cell with the same goal, and it
returns an error (both cells also general data):
=(IF(AB3=0,"Non Scoring Question",""))+(IF(AB3=1,"Normal Criteria",""))
It seems that the first IF statement works and as soon as the second is
added, the problem occurs.
Anybody know what I'm doing wrong?
Appreciate it.
other cell, and it works fine (both cells are general data):
=(IF(X3="Normal Criteria",1,0))+(IF(X3="Critical
Criteria",1.5,0))+(IF(X3="Non-Critical Criteria",0.5,0))+(IF(X3="Non-Scoring
Question",0,0))+(IF(X3="Very Critical Criteria",2,0))
I then use the following formula on another cell with the same goal, and it
returns an error (both cells also general data):
=(IF(AB3=0,"Non Scoring Question",""))+(IF(AB3=1,"Normal Criteria",""))
It seems that the first IF statement works and as soon as the second is
added, the problem occurs.
Anybody know what I'm doing wrong?
Appreciate it.