View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Domenic
 
Posts: n/a
Default #VALUE! displayed when referencing a formula cell

Try...

=IF(D4<"",D4*0.9*0.9,"")

Hope this helps!

In article ,
bazza825
wrote:

proper Wrote:

You use an IF statement in A2, but not in A3. Put the following in
A3:

=if(iserror(sum(...),"",(sum(...)))


I did briefly try that but got the context wrong. So i've tried it
again, as follows..

=if(iserror(sum(d4*0.9*0.9),"",(sum(d4*0.9*0.9))))

But i now get an error message saying that this is wrong... i can't see
where though :((

Damn my stupidity, i bet this is an easy fix as well :(

thanks again
barry