Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a formula or function, what do the symbols "" mean.
=IF(E78=0,"",IF(E78="","",(IF(H77="",(F77+1),(H77+ 1)))))
=IF(E77=0,"",IF(E77=1,"",((E77+F77)-1))) In the formulas, what does "" mean? The first formula is in column F and the second is in column H. I trying to debug a spreadsheet written by someone who is no longer with the company and this formula only seems to partially work. If I enter a number larger than 0 in E78, then the value in F78 becomes the sum of E78 and F77, and H78 becomes the sum of E78 and H77. If I enter a 0 in E78, then nothing appears in F78 or H78, but later rows indicate a #VALUE! error. The values are correct as long as 0 is not used, but I do not understand why the formula was written as it is. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions |