Thanks guys the =MIN(2000,B4*0.3)
works great. I didn't try the other. It's great to know help is out there
I might have to call on you guys again. I really appreceate the help.

Peter

"pinmaster" wrote:

Isn't that what I suggested in my second post???


"Harlan Grove" wrote:

pinmaster wrote...
Maybe something like:

=if(SUM(A1:A10)=100,100,SUM(A1:A100))
....

If so, why not

=MIN(100,SUM(A1:A10))

?