Formula help
 

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

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

Formula help
 

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

"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

Formula help
 

Thanks Ron & Tim

Things are working great

Thanks again

Chomp

"tim m" wrote:

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

"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