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