View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
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?