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