it's returning a single double quote?

are you sure your equation does not end in ...),"""") this would return a
single quote mark, but I am not sure what else would make it do that.

"Libby" wrote:

I lied. The formula isn't working right when w<1. It's returning " instead
of pb,immaterial or blank.
--
Libby


"bj" wrote:

=if(W1=1,if(T1-U1=0,"pb",if(and(T1-U1-100,T1-U1<=50),"immaterial","")),"")
I assume what you meant by T-U+-100 was just T-U-100

"Libby" wrote:

I want to write a formula to do the following:

If column w= 1 and column t-u <0 and column t-u <= 50 and column t-u +
-100 then return the word "immaterial" in column v else if column w=1 and
column t-u = 0 then return "pb" in column v else leave column v blank
--
Libby