L
links_now
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
answer to be 3 how would I do it or is it possible
S
Sandy
Type =IF(B4*C4/144<3,3,B4*C4/144) into D4 and then copy down
hth Sandy
hth Sandy
G
Gary''s Student
=MAX(SUM(B4*C4)/144 ,3)
S
SteveW
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
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
S
SteveW
Ignore mine in your case - I missed the word *minimum*
Steve
Steve
G
Gord Dibben
=MAX(3,SUM(B4*C4)/144)
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
D
David Biddulph
=MAX(3,(B4*C4)/144)
You don't need the SUM() function, as you aren't summing.
You don't need the SUM() function, as you aren't summing.
P
Pete_UK
Well, you could also say that you don't need the inner brackets <bg>
Pete
Pete
D
David Biddulph
True.
Touché.
--
David Biddulph
Touché.
--
David Biddulph
Pete_UK said: