How use value of a cell without turning #VALUE!
 

Hello I'm John. I'm trying to figure out how to use a specific value of a
cell but results in #VALUE! might be because the answer of a formula in there
(k11) is empty or "0".
I have
"=N12+IF(ISNUMBER($K$11+$K$14)=TIME(0,1,),IF(F14+ F11=TIME(0,1,),($K14*2)+IF($K11=TIME(0,1,),(K11) *2)))*D2",
it is just on k11*2 turns #value! but not in k14 because the answer of the
formula in that cell is "0:30".
Any advice...

How use value of a cell without turning #VALUE!
 

hi, John !

I'm trying to figure out how to use a specific value of a cell but results in #VALUE!
might be because the answer of a formula in there (k11) is empty or "0".
I have "=N12+IF(ISNUMBER($K$11+$K$14)=TIME(0,1,),IF(F14+ F11=TIME(0,1,),($K14*2)+IF($K11=TIME(0,1,),(K11) *2)))*D2"
it is just on k11*2 turns #value! but not in k14 because the answer of the formula in that cell is "0:30".
Any advice...

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.

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. :)