IF function

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top