| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does this formula work ?
Why does the following formula work the way it does ?
=MIN(IF({0,1,2,3}0,{0,1,2,3})) Using the Evaluate Formula dialog box, you see the IF test resolve to {FALSE,TRUE,TRUE,TRUE}. But the IF TRUE result returns {FALSE,1,2,3}. How does this formula replace the 0 with FALSE and leave the numbers unaffected ? - Ronald K. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
| why doesn't this formula work? | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| formula won't work | Excel Worksheet Functions | |||
Threaded Mode
