Formula to bring up to # but not over
 

I'm looking for a formula that will sum a series of numbers up to a max of
$10,000,000 and not go over.

So if the cells we
A1 B1 C1
8,700,000 5,000,000 10,000,000

A2 B2 C2
8,700,000 1,000,000 9,700,000

I would like a forumla that adds A1 and B1 so that the answer is a maxed at
10,000,000. Thanks

Formula to bring up to # but not over
 

=MIN(A1+B1,10,000,000)



"Woody13" wrote:

I'm looking for a formula that will sum a series of numbers up to a max of
$10,000,000 and not go over.

So if the cells we
A1 B1 C1
8,700,000 5,000,000 10,000,000

A2 B2 C2
8,700,000 1,000,000 9,700,000

I would like a forumla that adds A1 and B1 so that the answer is a maxed at
10,000,000. Thanks

Formula to bring up to # but not over
 

Woody, maybe this, =IF(A1+B110000000,10000000,A1+B1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Woody13" wrote in message
...
I'm looking for a formula that will sum a series of numbers up to a max of
$10,000,000 and not go over.

So if the cells we
A1 B1 C1
8,700,000 5,000,000 10,000,000

A2 B2 C2
8,700,000 1,000,000 9,700,000

I would like a forumla that adds A1 and B1 so that the answer is a maxed
at
10,000,000. Thanks

Formula to bring up to # but not over
 

Should be ....


=MIN(A1+B1,10000000)

"Toppers" wrote:

=MIN(A1+B1,10,000,000)



"Woody13" wrote:

I'm looking for a formula that will sum a series of numbers up to a max of
$10,000,000 and not go over.

So if the cells we
A1 B1 C1
8,700,000 5,000,000 10,000,000

A2 B2 C2
8,700,000 1,000,000 9,700,000

I would like a forumla that adds A1 and B1 so that the answer is a maxed at
10,000,000. Thanks