Home 
Search 
Today's Posts 
#1




A formula not working as the result of a previous formula?
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? 
#2




A formula not working as the result of a previous formula?
You cannot have a formula and a value in the same cell..
If this post helps click Yes  Jacob Skaria "Ed" wrote: 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? 
#3




A formula not working as the result of a previous formula?
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 ToolsFormula auditing, in Excel2007 you'll have to select the Formulas tab.  Kind regards, Niek Otten Microsoft MVP  Excel "Ed" wrote in message ... 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? 
#4




A formula not working as the result of a previous formula?
On Jul 21, 11:56*am, "Niek Otten" wrote:
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 ToolsFormula auditing, in Excel2007 you'll have to select the Formulas tab.  Kind regards, Niek Otten Microsoft MVP  Excel "Ed" wrote in message ... 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? Hide quoted text   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? 
#5




A formula not working as the result of a previous formula?
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 nonbreaking spaces or other nonprinting characters in the cell with your number.  David Biddulph "Ed" wrote in message ... 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? ... 
#6




A formula not working as the result of a previous formula?
On Jul 21, 1:07*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: 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 nonbreaking spaces or other nonprinting characters in the cell with your number.  David Biddulph "Ed" wrote in message ... 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? ... Hide quoted text   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? 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
copy formula result (text) only  without copying formula  Excel Discussion (Misc queries)  
multiply formula where 1 cell has a (sumif) formula as a result  Excel Worksheet Functions  
Advanced formula  Return result & Show Cell Reference of result  Excel Worksheet Functions  
formula is displayed as literal text instead of formula result  Excel Discussion (Misc queries)  
Cell doesn't show formula result  it shows formula (CTRL + ' doe.  Excel Worksheet Functions 