My formula in cell C10 is: =IF(C7="Purchase",B10,""). C7 is currently blank, but the formula is calculating it as TRUE and inputting the value from B10. The Logical test is not TRUE, so what is going on?
My formula in cell C10 is: =IF(C7="Purchase",B10,""). C7 is currently blank, but the formula is calculating it as TRUE and inputting the value from B10. The Logical test is not TRUE, so what is going on?
no idea ,it should work perhaps c7 has some leading or trailing spaces or some other "invisible" character
what do=CODE(LEFT(UPPER(C7))) and =CODE(RIGHT(UPPER(C7))) they should return 80 and 69 respectively
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I get a #VALUE with both of the left and right formulas.
that is just wrong , put the word purchase in a spare cell then reference that with both formulas what do you get?
I get the 80 and 69 now. I have this same formula in a new worksheet I just opened up and it works perfectly - I can't figure it out.
If I enter in any kind of text or number into C7, then the logical test returns FALSE, as it should. Only when the cell is left blank, which is what I want to do, is it screwing up the formula.
ok #value if blank which is correct, and 80/69 when "purchase" is in cell . formula should work fine
post a workbook where this isn't working(is calculation set to auto?)
Select the offending cell, and only that cell, and use 'Clear All'. That should remove any stray stuff. You can also use the 'Clean' function to remove unprintable characters or the 'Trim' function to remove stray spaces in a cell.
Hope that helps...
for some reason you have transition formula evaluation turned on in options
Excel 2010 Options > Advanced > and then uncheck Transition formula evaluation.(under lotus compatibility settings)
Last edited by martindwilson; 11-28-2012 at 05:08 PM.
THANK YOU! I have no idea what that is, but it's fixed and the formula works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks