Combining IF Statements with a Max?

Baront

New Member
Joined
Nov 25, 2011
Messages
3
Hi,

I'm having a mental block here. I need the below statement to have a max value of (B14*B4) in the instance where (B17-B19)*0.7 exceeds (B14*B4),

IF(B17-B19<=B14*B4,B14*B4,(B17-B19)*0.7)

I don't know if this helps, but this statement computes the correct max value of (B14*B4), but does not compute less than that,

IF(B17-B19>=B14*B4,B14*B4,(B17-B19)*0.7)

I'm new to this, so I don't know if I need to combine the two or just set a max to the first one. I appreciate any help.

TIA.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Baront

New Member
Joined
Nov 25, 2011
Messages
3
Mr. Poulsom,

You nailed it! I think I was trying to make it far more difficult than it needed to be. Thanks for the welcome and the guidance.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,712
Messages
5,597,720
Members
414,168
Latest member
Manapo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top