View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kittronald kittronald is offline
external usenet poster
 
Posts: 162
Default 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.