SUM/SUMIF with <= Results

[Arcaila]

Column D should either be the sum of Column C multiplied by 272 or the figure in Column B if the sum of Column C multiplied by 272 is greater or equal to Column B. I've tried SUMIF expressions with nothing working. I'm lost. I am a beginner to intermediate level user with Excel. Formulas are challenging beyond sums and averages.

EX: 1,350 x 272 = 367,200. Column D should show the figure in Column B, as the sum is greater than Column B.
EX: 1,150 x 272 = 312,800 (if we change C to 1,150). Column D should show 312,800.

Thank you for any help you can offer.

 

[Cubist]

Column D should either be the sum of Column C multiplied by 272 or the figure in Column B if the sum of Column C multiplied by 272 is greater or equal to Column B

The result of multiplication is called product, not sum.

Try:

Book1
	B	C	D
6	313,900	1,350	313,900
7	313,900	1,150	312,800
Sheet9

Cell Formulas
Range	Formula
D6:D7	D6	=MIN(B6,C6*272)

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D
1
2		313900	1350	313900
3		313900	1150	312800
Data

Cell Formulas
Range	Formula
D2:D3	D2	=MIN(272*C2,B2)

 

[Arcaila]

That worked perfectly. Didn't even consider the MIN function. Thank you Cubist and Fluff!

 

[Fluff]

Glad we could help & thanks for the feedback.