S S Wrote:
Based on area.

B15 = width
C15 =length
D15 =Total sq meters
E15 = tile size (currently sq cms)
F15 = tiles required

this is the formula I am using =D15/(E15/10000)

What I want to do is in E15 just put in the tile size (say a 30cm
tile)
rather than sq cms and have the formula convert this to sq cms, so
somehow
need to sq the number in E15. At least that is how my brain is telling
me.

thanks
Hi S S,

Always a problem working out how many tiles you need to do a job,
depends on shape being tiled, pattern or plain tile, size of tile

As tiles don't always come in squares, how about this?
B15 enter width ie. 20
C15 enter length ie. 30
D15 enter sq. metres ie. 10
E15 enter, =B15*C15
F15 enter, =ROUNDUP(D15/E15*10000,0.5)
This should take account of waste and cutting in

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=571138