Thread: Equations
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 9
Default Equations

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