Formula help

T

The Chomp

Good Day;
I am trying to do the following;

sum cell A1 * A2 cells that total $135.98
I have a top dollar amount of $125
If the total of 2 cells is greater than (>) $125.00 I want the total cell to
have the value $125.00

Any ideas

Thanks

Chomp
 
R

Ron Coderre

Try this:

=MIN(SUM(A1:A2),125)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
T

tim m

=IF(A1+A2>125,125,A1+A2)
I wasn't sure about the wording of your example but you could see if this
will do the trick.
 
Top