Formula Needed!

R

Roman

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.
 
R

Ragdyer

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!
==============================­================
 

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

Similar Threads

Formula Question 3
Excel 97 Find last in list of similiar numbers 0
formula to look at current date and markdown date to give price 4
using an IF function for a total 4
adding columns with decimals out to far 3
Formulas 2
Is it possible to have a multiple lookup formula. 1
Difficult Question Inside! Anyone up for it? (formatted better, I hope) 2

Top