Need to get minimum difference

S

sleek

I need to get the minimum or zero difference,
there are 3 constants here:-

GOAL to attains(constants)
456,270.00
525,400.00
522,600.00

DATA to use
A B C
41,150.00 55,200.00 53,250.00
53,250.00 58,100.00 53,250.00
53,250.00 62,950.00 67,760.00
65,840.00 62,950.00 67,800.00
67,800.00 69,720.00 87,150.00
96,850.00 147,200.00 193,600.00
147,200.00

523340.00 456120.00 522810.00 (total of column A,B,C)
525400.00 456270.00 522800.00 (constants)
-60 -150 210 Difference)
Anyone with formula or macro for me to get minimum or zero difference.
 
S

sleek

I need to get the minimum or zero difference,

there are 3 constants here:-



GOAL to attains(constants)

456,270.00

525,400.00

522,600.00



DATA to use

A B C

41,150.00 55,200.00 53,250.00

53,250.00 58,100.00 53,250.00

53,250.00 62,950.00 67,760.00

65,840.00 62,950.00 67,800.00

67,800.00 69,720.00 87,150.00

96,850.00 147,200.00 193,600.00

147,200.00



523340.00 456120.00 522810.00 (total of column A,B,C)

525400.00 456270.00 522800.00 (constants)

-60 -150 210 Difference)

Anyone with formula or macro for me to get minimum or zero difference.

Also i forgot to mention the numbers are interchangeable, but i need a difference very close to zero or zero.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top