Try this:

=MAX(B15/2000,95)*15.32

HTH,
Elkar



"enoch2012" wrote:


We have a spreadsheet at work where in B16 we use this formula:

=SUM(B15/2000*15.32)

That is good except when B15/2000 is less then 95. In that case we
need to just multiply 95*15.32. Is there anyway to do this in one step
when this happens?

Thanks for the help it is much appreciated.

Frank


--
enoch2012
------------------------------------------------------------------------
enoch2012's Profile: http://www.excelforum.com/member.php...o&userid=34722
View this thread: http://www.excelforum.com/showthread...hreadid=544852