Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"Bob Phillips" wrote:
I don't understand, what difference does it make? Consider the following example: =if(and(a1<0, b1/a10), "foo", "bar") This results in #DIV/0 when A1 is zero, despite clear intentions to avoid it. That formula must be rewritten, for example: =if(a1=0, "bar", if(b1/a10, "foo", "bar")) It would make a difference with OR, but not AND. It makes no more nor less difference with OR than with AND. I could write a similar example above using OR(a1=0,b1/a1<=0). With some programming languages, many people rely on the abortive left-to-right evaluation of boolean expressions, which have operators for "and", "or", etc. It is most useful (albeit dubious) when the evaluation of subexpressions has side-effects. But in those languages, all function parameters are evaluated before calling the function. So it is the case with Excel's functions AND(), OR(), etc. These are (obviously) functions, not operators. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |