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