 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Need formula for calculating even lots of material based on square feet
How or what formula can I use to calculate an IF statement and then multiply by a set dollar amount in multiples, I am trying to calculate the amount of grout required for an area of floor tile based on the number of square feet. Where one bage of grout covers 100 sqft of tile.Grout is purchased by the bag at $14.00. If I need grout for 150 sqft of tile, I will have to purchase 2 full bags for the job and include the total cost. As the square footage exceeds the 100 square foot increment I require another full bag. I need the formula to give me answers in even bag prices. Thanks, Mike Twidley@cableone.net =INT(floor_area/100)*grout_price (it works well on paper too!)  Signature--- HTH Bob (change the xxxx to gmail if mailing direct) > How or what formula can I use to calculate an IF statement and then > multiply by a set dollar amount in multiples, [quoted text clipped - 12 lines] > > Twidley@cableone.net Bob, Not really. INT doesn't work well in Excel, or on paper . =ROUNDUP(floor_area/100,0)*grout_price would be better. HTH, Bernie MS Excel MVP > =INT(floor_area/100)*grout_price > [quoted text clipped - 16 lines] >> >> Twidley@cableone.net Why doesn't INT work well in Excel? """ > Bob, > [quoted text clipped - 36 lines] > >> > >> Twidley@cableone.net Ilia Bernie didn't mean that INT doesn't work well in Excel. He meant that INT was not the correct solution for the stated problem. INT works fine for its intended purpose. HTH Otto > Why doesn't INT work well in Excel? > [quoted text clipped - 40 lines] >> >> >> >> Twidley@cableone.net Hi You need the Roundup formula =ROUNDUP(Area/bag_cover,0)*bag_price =ROUNDUP(150/100,0)*14 SignatureRegards Roger Govier > How or what formula can I use to calculate an IF statement and then > multiply by a set dollar amount in multiples, [quoted text clipped - 12 lines] > > Twidley@cableone.net >How or what formula can I use to calculate an IF statement and then >multiply by a set dollar amount in multiples, [quoted text clipped - 12 lines] > >Twidley@cableone.net With sq ft of tile in A1: =CEILING(A1/100,1)*14 --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.