Thread: how to identify
View Single Post
  #6   Report Post  
John Michl
 
Posts: n/a
Default how to identify

In cell A1 through A5, enter the five numbers.
In cell B1 through B5, enter 0 (zero)
In cell B6 enter =SumProduct(A1:A5,B1:B5)
Choose from the menu, Tools Solver
Set Target Cell to B6
Equal to Value of 54,781.43
By Changing Cells B1:B5
Subject to the Constraint B1:B5 = binary
Click Solve and those values that are part of the answer will show a
"1" next to them.

- John