Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I half-noticed a long while ago that whenever there is an error within the arguments to test in a logical function, the final result will also be an error. But it just stroke me today that if I have something like... A1: 1 A2: =OR(A1=1,A1=2/0) ....A2 will return an error despite the fact the first argument returned TRUE, which in any case should validate the OR... shouldn't it? Is there a trick to go around this problem without stacking functions? Thanks for any input, Feelu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Max (A1:A1), relating to other cells | Excel Worksheet Functions | |||
Question relating to Named Ranges which exist in another workbook. | Excel Discussion (Misc queries) | |||
Relating cells | Excel Worksheet Functions | |||
Relating fields | Excel Discussion (Misc queries) | |||
Relating text to a value | Excel Worksheet Functions |