Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Polynomial equations MartinW Excel Worksheet Functions 11 May 15th 06 11:55 AM
Trendline Equations Steve Morris Charts and Charting in Excel 1 January 11th 06 04:56 PM
Trendline Equations rpicheme07 Charts and Charting in Excel 2 November 20th 05 01:22 PM
Excel equations ATK Excel Discussion (Misc queries) 3 October 3rd 05 09:05 PM
Excel equations... thanatologist Excel Discussion (Misc queries) 2 March 25th 05 01:25 AM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"