Formula help
Try this:
=MIN(SUM(A1:A2),125)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"The Chomp" wrote:
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
|