How use value of a cell without turning #VALUE!

[JC-PS]

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

 

[Héctor Miguel]

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.

 

[JC-PS]

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.