IF function
 

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.

IF function
 

First, the addition operator (+) gives the #VALUE! error when given a
non-numeric argument (like the null string ""). Your formula should work
if you use the concatenation operator (&) instead.

In article ,
vertigo wrote:

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.