| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Arguments
Not too srue what you are driving at here. You can use the logical And / Or
functions =if(and(A1 = 1, B1 = 1), true, False) Which can be simplified to =and(A1 = 1, B1 = 1) there is also an or function =or(a1 = 1, B1 = 1) finally you could use nested if functions this mimics the above or function =if(A1 = 1, true, if(b1 = 1, true, false) And this mimics the and function =if(A1 = 1, if(B1 = ,true, false), false) -- HTH... Jim Thomlinson "Jessica" wrote: Is there any way of having more than one scenario in an arguement so that the "TRUE" answer will depend on more than one "IF" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stumped on Lookup Function | Excel Discussion (Misc queries) | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Event hundler to control the Excel function arguments | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
