#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
|