the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

Type =IF(B4*C4/144<3,3,B4*C4/144) into D4 and then copy down

hth Sandy

"
wrote in message ...
the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

=MAX(SUM(B4*C4)/144 ,3)
--
Gary''s Student
gsnu200707


" wrote:

the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

Depends on the meaning of your data.

If (and 144 is a clue - square inches in a square foot) you want to round
your
answer up to the next whole number
then use the =ROUNDUP() function
ie =ROUNDUP(SUM(B4*C4)/144,0)

Steve


On Fri, 23 Feb 2007 17:58:35 -0000,
wrote:

the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

Ignore mine in your case - I missed the word *minimum*

:(

Steve


On Fri, 23 Feb 2007 18:19:01 -0000, SteveW wrote:

Depends on the meaning of your data.

If (and 144 is a clue - square inches in a square foot) you want to
round your
answer up to the next whole number
then use the =ROUNDUP() function
ie =ROUNDUP(SUM(B4*C4)/144,0)

Steve


On Fri, 23 Feb 2007 17:58:35 -0000,
wrote:

the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

=MAX(3,SUM(B4*C4)/144)


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 09:58:35 -0800,
wrote:

the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

=MAX(3,(B4*C4)/144)

You don't need the SUM() function, as you aren't summing.
--
David Biddulph

"
wrote in message ...
the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible

Well, you could also say that you don't need the inner brackets <bg

Pete

On Feb 23, 7:22 pm, "David Biddulph" wrote:
=MAX(3,(B4*C4)/144)

You don't need the SUM() function, as you aren't summing.
--
David Biddulph

"
wrote in ...



the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible- Hide quoted text -

- Show quoted text -

True.
Touché.
--
David Biddulph

"Pete_UK" wrote in message
s.com...
Well, you could also say that you don't need the inner brackets <bg

On Feb 23, 7:22 pm, "David Biddulph" wrote:
=MAX(3,(B4*C4)/144)

You don't need the SUM() function, as you aren't summing.

"
wrote in
...

the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the
minimum
answer to be 3 how would I do it or is it possible