Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turning off autocomplete for one cell only | Excel Discussion (Misc queries) | |||
keeps turning off | Excel Worksheet Functions | |||
Turning #N/A into an empty cell | Excel Discussion (Misc queries) | |||
Turning #N/A to a zero...?? | Excel Discussion (Misc queries) |