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.