Need formula for calculating even lots of material based on square feet

  • Thread starter Thread starter Twidley
  • Start date Start date
T

Twidley

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

(e-mail address removed)
 
=INT(floor_area/100)*grout_price

(it works well on paper too!)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Hi

You need the Roundup formula

=ROUNDUP(Area/bag_cover,0)*bag_price

=ROUNDUP(150/100,0)*14
 
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
 
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
 
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

(e-mail address removed)


With sq ft of tile in A1:

=CEILING(A1/100,1)*14



--ron
 
Back
Top