IF Condition help (I believe)

[capricorn123]

Good morning Mr. Excel community,

I have a questions and wondering if you can help!

<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {background:yellow; mso-pattern:black none;}.xl64 {background:#92D050; mso-pattern:black none;}--></style>[TABLE="width: 435"]
<tbody>[TR]
[TD="width: 87"][/TD]
[TD="width: 87"]B[/TD]
[TD="width: 87"]D[/TD]
[TD="width: 87"]E[/TD]
[TD="width: 87"]F[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64"]B1*D1[/TD]
[TD="align: right"]26.22[/TD]
[TD="align: right"]508.7[/TD]
[/TR]
</tbody>[/TABLE]

If B1*D1 (Cell D3) value is in the range of E3 and F3, amount will show in B3. If it is less than E3 (26.22) then show 26.22 (E3 value) and if more than F3 (508.70) then show 508.70 (F3 value).

Thank you in advance!

 

[Joe4]

Try:

=MIN(MAX(B1*D1,E3),F3)

 

[capricorn123]

Thank you so much Joe, it did work!

 

[Joe4]

You are welcome.