Minimum Formula

[George]

Excel 2007
Hello, I am using the following formula;
=Sum((A3*2+B3*2)*$R$2)
This formula is in cell R3, I would like to use the above formula, but I do
not want the value in cell R3 to drop below .38

 

[Joel]

=if(Sum((A3*2+B3*2)*$R$2)<.38,.38,Sum((A3*2+B3*2)*$R$2))

 

[Ron Rosenfeld]

Excel 2007
Hello, I am using the following formula;
=Sum((A3*2+B3*2)*$R$2)
This formula is in cell R3, I would like to use the above formula, but I do
not want the value in cell R3 to drop below .38

=max(Sum((A3*2+B3*2)*$R$2),0.38)

--ron

 

[David Biddulph]

Two questions:

Firstly, what are you wanting the SUM function to do for you? What do you
want it to add to (A3*2+B3*2)*$R$2 ?
Why
=if(Sum((A3*2+B3*2)*$R$2)<.38,.38,Sum((A3*2+B3*2)*$R$2)) instead of just
=if((A3*2+B3*2)*$R$2<.38,.38,(A3*2+B3*2)*$R$2) ?

Secondly, wouldn't
=MAX((A3*2+B3*2)*$R$2,.38) be easier ?

 

[Ron Rosenfeld]

=max(Sum((A3*2+B3*2)*$R$2),0.38)

--ron

Now that I've had my morning coffee, I note that your SUM function is
superfluous.

=max((A3*2+B3*2)*$R$2,0.38)

or even simpler:

=MAX((A3+B3)*2*$R$2,0.38)

--ron