Formula to bring up to # but not over

[Guest]

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 were:
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

 

[Guest]

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

 

[Paul B]

Woody, maybe this, =IF(A1+B1>10000000,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

 

[Guest]

Should be ....


=MIN(A1+B1,10000000)

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