<div>
1) There is a MIN(...) function in Excel which is more comfortable to use in the case you describe, e.g. the initial working formula would be:<br />

<pre><code id="code-20-37752856-1">=MIN(120,(F11*0.04))</code></pre>
<br />
2) What do you mean by &quot;section&quot;? You don't need to use SUM(...) function for a 1-item list like SUM(F11*0.04).
</div>


1) There is a MIN(...) function in Excel which is more comfortable to use in the case you describe, e.g. the initial working formula would be:


=MIN(120,(F11*0.04))


2) What do you mean by "section"? You don't need to use SUM(...) function for a 1-item list like SUM(F11*0.04).

<div>
Thanks for the quick response, both work perfectly..
</div>


Thanks for the quick response, both work perfectly..

<div>
Since both work perfectly could you please assign several points to me as well?
</div>


Since both work perfectly could you please assign several points to me as well?

<div>
I had to ask for the question to be reopened as I had meant to accept both solutions. This is now done. Thanks to both
</div>


I had to ask for the question to be reopened as I had meant to accept both solutions. This is now done. Thanks to both

<div>
<div class="content wysiwyg-content">
I have the following formula that works.<br />
=IF((F11*0.04)&gt;120,120,(F1<wbr />1*0.04))<br />
<br />
I need to add a section that would calculate a minimum value of say 5. As in this formula<br />
=IF(SUM(F11*0.04)&lt;5,5,SUM(<wbr />F11*0.04))<wbr /><br />
<br />
I basically need a combination of the two, so F11*0.04 with a minimum value of 5 amnd a maximum of 120.<br />
<br />
Any help greatly appreciated
</div>
</div>


I have the following formula that works.
=IF((F11*0.04)>120,120,(F11*0.04))

I need to add a section that would calculate a minimum value of say 5. As in this formula
=IF(SUM(F11*0.04)<5,5,SUM(F11*0.04))

I basically need a combination of the two, so F11*0.04 with a minimum value of 5 amnd a maximum of 120.

Any help greatly appreciated

Excel Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.