Combining IF Statements with a Max?

[Baront]

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.

 

[Andrew Poulsom]

Welcome to MrExcel.

Is it?

=MIN(B14*B4,(B17-B19)*0.7)

 

[Baront]

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.