Combination of numbers using simple aritmetic operations to get some number as solution

**net.rider** · 04-24-2012, 11:15 AM

i have randomly given 6 number i need to find combination to get some number in this example 104
i can use next operators + - / * ) (
i dont must to use all numbers

5
6
4
5
2
3

need to get 104
solution for this example 5*5*(6-2)+4=104

How to do that in excel?
Thanks

**royUK** · 04-24-2012, 12:57 PM

It's not simple arithmetic, You could try using Solver.

**sem** · 04-24-2012, 01:15 PM

Hi net.rider,
Try this vb code by Wonderful"PGC1"
and it use all available numbers;

Please Login or Register  to view this content.

I hope this is what you're looking for.

Please Login or Register  to view this content.

Regards

**net.rider** · 04-24-2012, 04:13 PM

Thank you very much sem, you save me a lot of work

Combination of numbers using simple aritmetic operations to get some number as solution

LinkBack

Thread Tools

Rate This Thread

Display

Combination of numbers using simple aritmetic operations to get some number as solution

Re: Combination of numbers using simple aritmetic operations to get some number as soluti

Re: Combination of numbers using simple aritmetic operations to get some number as soluti

Re: Combination of numbers using simple aritmetic operations to get some number as soluti

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions