How use value of a cell without turning #VALUE!
"Héctor Miguel" wrote:
1) note that this part of your formula: - ISNUMBER($K$11+$K$14)
- returns TRUE if K11 and K14 contains numbers or they are empty
- returns FALSE if any of K11 or K14 contains strings
- also, any #VALUE! error is translated to dependant cells/formulae
2) I don't think that TRUE/FALSE can be "evaluated" as - =TIME(0,1,) -???-
3) if the expression "K11*2" results in the #VALUE! error, perhaps K11 contains string values
note that any attempt to multiply text-by-number results in #VALUE! errors (i.e =""*2)
hth,
hector.
Thanks ones again Hector Miguel. Your answer has been very helpful.
This time, I've just breakdown the formulae & reduce it to:
"=((n12+(k11+k12)*2)*d2" I was missing up text ("")
with time (h:mm). The previous formula on k11 and k14 was:
"=if(f14=$n$5,g14-f14,"")" it was here in false area of the conditional formula that I changed it to "time(0,0,)" and up to the moment doing the work. I appreciate your time. :)
|