Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I figure square footage for 2 or 3 numbers in a row?
I need to figure square footage of 2 dimensions, height, width, , leaving out
a thrid number in the same cell, then multiply by a separate number. Any way to do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I figure square footage for 2 or 3 numbers in a row?
Post a sample of your dimensions.
You might be able to do that with LEFT(), MID() and RIGHT()...? A looong shot guess would be something like this: =LEFT(F1,1)*MID(F1,3,1)*H1 Where your 3 numbers in F1 are 2x5x10, and H1 has the number 8, which you want to multiply by. Returns 80. Falls apart with two-digit dimensions or a combo of one and two! HTH Regards, Howard "Sandi" wrote in message ... I need to figure square footage of 2 dimensions, height, width, , leaving out a thrid number in the same cell, then multiply by a separate number. Any way to do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate square footage in excel ? | Excel Discussion (Misc queries) | |||
How do I a rotate my square radar chart (square-diamond)? | Charts and Charting in Excel | |||
Compare house plans to price/square footage, what template to use? | Excel Discussion (Misc queries) | |||
Want to calculate square footage of shapes in excel | Excel Discussion (Misc queries) | |||
Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) |