| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formula Needed!
I need a formula that finds the closest sum of the list of bills to the specified amount, i.e Bills $ 30.00 $ 20.00 $ 30.00 Amount $ 70.00 In this case formula should highlight or indicate in some way cells with amounts $30.00 and $30.00 and show the total of these cells. -- Roman ------------------------------------------------------------------------ Roman's Profile: http://www.excelforum.com/member.php...o&userid=24442 View this thread: http://www.excelforum.com/showthread...hreadid=380407 |
|
#2
|
|||
|
|||
|
Try this, Roman:
http://www.mrexcel.com/pc09.shtml ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Roman" wrote in message ... I need a formula that finds the closest sum of the list of bills to the specified amount, i.e Bills $ 30.00 $ 20.00 $ 30.00 Amount $ 70.00 In this case formula should highlight or indicate in some way cells with amounts $30.00 and $30.00 and show the total of these cells. -- Roman ------------------------------------------------------------------------ Roman's Profile: http://www.excelforum.com/member.php...o&userid=24442 View this thread: http://www.excelforum.com/showthread...hreadid=380407 |
|
#3
|
|||
|
|||
|
See if this old post of Ken Wright's can help:
http://tinyurl.com/a82os -- HTH, RD ==============================*================ Please keep all correspondence within the Group, so all may benefit! ==============================*================ "Roman" wrote in message ... I need a formula that finds the closest sum of the list of bills to the specified amount, i.e Bills $ 30.00 $ 20.00 $ 30.00 Amount $ 70.00 In this case formula should highlight or indicate in some way cells with amounts $30.00 and $30.00 and show the total of these cells. -- Roman ------------------------------------------------------------------------ Roman's Profile: http://www.excelforum.com/member.php...o&userid=24442 View this thread: http://www.excelforum.com/showthread...hreadid=380407 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Formula needed | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
