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.
=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.
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.
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.
" " 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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.