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