thank you. from there I was able to figure out my other question by coming
up with =min(2.5%*c17,30.00). thanks for such a simple fix.

"Cutter" wrote:


in C20 type this formula:

=MAX(C5,C17)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512776