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

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)
 
B

Bob Phillips

=INT(floor_area/100)*grout_price

(it works well on paper too!)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
R

Roger Govier

Hi

You need the Roundup formula

=ROUNDUP(Area/bag_cover,0)*bag_price

=ROUNDUP(150/100,0)*14
 
B

Bernie Deitrick

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
 
O

Otto Moehrbach

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
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top