Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 21st 09, 04:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 5
Default 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   Report Post  
Old July 21st 09, 04:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,520
Default 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   Report Post  
Old July 21st 09, 04:56 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default 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   Report Post  
Old July 21st 09, 05:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 5
Default 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   Report Post  
Old July 21st 09, 06:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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
non-breaking spaces or other non-printing 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   Report Post  
Old July 21st 09, 06:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 5
Default 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
non-breaking spaces or other non-printing 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy formula result (text) only - without copying formula Mulberry Excel Discussion (Misc queries) 2 October 2nd 08 09:51 AM
multiply formula where 1 cell has a (sumif) formula as a result kcip Excel Worksheet Functions 1 May 3rd 07 07:41 AM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM
formula is displayed as literal text instead of formula result carlossaltz Excel Discussion (Misc queries) 2 July 1st 05 09:26 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM


All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017