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

=MIN(B15/2000,95)*15.32

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"enoch2012" wrote
in message ...

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

Frank,

Try,

=IF(B15/2000<95,(95*15.32),(B15/2000)*15.32)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544852

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

Thanks Steve that is exactly what we needed.


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