A formula not working as the result of a previous formula?

[Ed]

Formula is =IF(AND(E133="Liss", ISNUMBER(G133)), F133, "0"), where
F133 is the result of its own formula. So far I'm just getting "0"
for this, even though otherwise the criteria for the formula are met.
Is that because F133 is the result of its own formula? If so, is
there anything I can do about it?

 

[Jacob Skaria]

You cannot have a formula and a value in the same cell..

If this post helps click Yes

 

[Niek Otten]

No, it's not because F133 is a formula; that should work OK.
Use Evaluate Formula to find out how Excel evaluates the formula. I think
before Excel2007 it was in Tools>Formula auditing, in Excel2007 you'll have
to select the Formulas tab.

 

[Ed]

No, it's not because F133 is a formula; that should work OK.
Use Evaluate Formula to find out how Excel evaluates the formula. I think
before Excel2007 it was in Tools>Formula auditing, in Excel2007 you'll have
to select the Formulas tab.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel






- Show quoted text -

Excel evaluates this formula as G133 not being a number, which is
confusing because that cell plainly is a number and I even reformatted
the whole column to be numbers, just to be safe. Any thoughts?

 

[David Biddulph]

Changing the format wouldn't change the content from text to number, as
formatting affects only the display, not the contents.

Use =ISNUMBER(G133) and =ISTEXT(G133) to check what you've got. If it looks
like a number but is being regarded as text, you may have spaces or
non-breaking spaces or other non-printing characters in the cell with your
number.

 

[Ed]

Changing the format wouldn't change the content from text to number, as
formatting affects only the display, not the contents.

Use =ISNUMBER(G133) and =ISTEXT(G133) to check what you've got.  Ifit looks
like a number but is being regarded as text, you may have spaces or
non-breaking spaces or other non-printing characters in the cell with your
number.
--
David Biddulph






- Show quoted text -

That seems to have been it: there seems to have been a hidden or
invisble space or something that was making the cell read as non-
number. Any ideas on how to input numbers in to the G column and not
have to worry about this?