Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Polynomial equations | Excel Worksheet Functions | |||
Trendline Equations | Charts and Charting in Excel | |||
Trendline Equations | Charts and Charting in Excel | |||
Excel equations | Excel Discussion (Misc queries) | |||
Excel equations... | Excel Discussion (Misc queries) |