Minimum Formula
 

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

Minimum Formula
 

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



"George" wrote:

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

Minimum Formula
 

On Wed, 4 Mar 2009 03:46:03 -0800, George
wrote:

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

Minimum Formula
 

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 ?
--
David Biddulph

"Joel" wrote in message
...
=if(Sum((A3*2+B3*2)*$R$2)<.38,.38,Sum((A3*2+B3*2)* $R$2))



"George" wrote:

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

Minimum Formula
 

On Wed, 04 Mar 2009 07:00:52 -0500, Ron Rosenfeld
wrote:

On Wed, 4 Mar 2009 03:46:03 -0800, George
wrote:

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

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