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