Formula in Office 2013

[klatlap]

Can someone please explain why a simple formula that has always worked now doesn't always work in Office2013

=if(A1="","",1

Yes there is a formula in A1 but that has always worked except now

 

[Jonmo1]

Can you define "doesn't always work" ??

What do you mean 'doesn't always' ?
To me that says sometimes it DOES work.
So in which cases DOES it work, and which cases does it NOT work?

And what does Not Work mean?
Do you get an error? What error?
Do you get the wrong result? What result DO you get? What result did you expect?

What do you actually expect the formula to do ?
The formula you posted isn't even complete, though I'm sure that's just a result of you manually typing it into the thread, instead of just copying it from Excel to the Thread.

 

[klatlap]

no error, here are 2 formulas.

=IF(AM3="","",AM3) works fine

=IF(AM3="","",IF(AO4="",(($Q$3*$Q$7-$Q$3)+$Q$5)*0.92-(($Q$3*$Q$7-$Q$3)+$Q$5),IF(AX4=0,AJ2*T4,AW4*T4))) This should result in a blank cell like the first formula, but instead it continues to process the calculation.

 

[Jonmo1]

The logical conclusion is that the first formula is not doing exactly what you think it is.
AM3 is probably not really blank, but it just looks blank.
So the AM3="" condition is actually FALSE, and the formula is returning the contents of AM3.
But the contents of AM3 'appears' to be blank, but it's really not.
Maybe it contains a space, or a 'hard return' or some other strange character.

What do these return
=AM3=""
=LEN(AM3)

 

[klatlap]

False and 1 so i guess you are correct, it is a Vlookup, i will try to add Trim(Clean( to my formula and associated formulas, not sure what else would work.

 

[Jonmo1]

Can you post that Vlookup?

 

[klatlap]

=IF(ISNA(TRIM(CLEAN(VLOOKUP($AB$4,Results!$T$2:$W$200,2,0))))," ",TRIM(CLEAN(VLOOKUP($AB$4,Results!$T$2:$W$200,2,0))))

I added the trim clean, didn't help so i did another work around to solve this, but would be great to solve the original issue for future projects.

 

[Jonmo1]

=IF(AM3="","",AM3)

=IF(ISNA(TRIM(CLEAN(VLOOKUP($AB$4,Results!$T$2:$W$200,2,0))))," ",TRIM(CLEAN(VLOOKUP($AB$4,Results!$T$2:$W$200,2,0))))

" " is not the same thing as ""
" " is actually a SPACE character.

So your vlookup, or actually the IF(ISNA), is putting a SPACE in the cell, not an empty string.
So if the vlookup is an error, then AM3 = " "
therfore
AM3="" is indeed FALSE.