Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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