formula help please....

[enoch2012]

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

 

[Bob Phillips]

=MIN(B15/2000,95)*15.32

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[SteveG]

Frank,

Try,

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

HTH

Steve

 

[Guest]

Try this:

=MAX(B15/2000,95)*15.32

HTH,
Elkar

 

[enoch2012]

Thanks Steve that is exactly what we needed.