Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
yes you need to square your tile size in cm and then divide by 10000(ie
100X100) so your formula would be =a3/(power(a4,2)/10000),where a3 is the sq metres of you r room and a4 s your tile size in cm -- paul remove nospam for email addy! "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
Try this:
=D15/(E15^2/10000) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "S S" wrote in message k... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
That worked perfectly...thanks
"paul" wrote in message ... yes you need to square your tile size in cm and then divide by 10000(ie 100X100) so your formula would be =a3/(power(a4,2)/10000),where a3 is the sq metres of you r room and a4 s your tile size in cm -- paul remove nospam for email addy! "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
"oldchippy" wrote in message ... 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 Old chippy I appreciate your help but its actually for tiling work in Turkey (part of a forum of Turkish owners) and in Turkey they have square tiles or square tiles. And I need to keep this as simple as possible for other members to be able to use it, I will get questions like `how do I measure a tile` I know it sounds stupid but............. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |