Thread
:
help with formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
paul
external usenet poster
Posts: 247
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
Reply With Quote
paul
View Public Profile
Find all posts by paul