Bernard wrote on Mon, 17 Sep 2007 18:07:32 -0300:

BL But this will be approximate: suppose you need tile 45 by
10 at a
BL wall; you need not discard the remainder since it will give
BL a second 45 by 10 unit.

BL Time to consult a DIY book? Or overpuchase at a store which
BL will take back unused items (my approach to carpentry every
BL time!) best wishes
BL --
BL Bernard V Liengme
BL Microsoft Excel MVP
BL www.stfx.ca/people/bliengme
BL remove caps from email

BL "rob" wrote in message
BL ...
?? I am looking for a formula to define the number of tiles I
?? need (full equivalent) to put in a room with an L-shape. I
?? have tiles size 45 by 45 or 60 by 60 cm. I can calculate
?? the net size of the floor of the room, but also would like
?? to know how many tiles I need to order.
?? Any idea how excel can help me with such formula?

As Bernard suggests, you hardly need Excel. If an integral
number of tiles will overlap the space, so be it! It's much
better to have a few too many than a few too little. I don't
think I would try desperate measures to fit whole tiles.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not