+ Reply to Thread
Results 1 to 7 of 7

I am looking for a formula in Excel 2007 thta help me determine square footage by room..

Hybrid View

slebron I am looking for a formula in... 02-27-2013, 03:37 PM
uxr Re: I am looking for a... 02-27-2013, 03:39 PM
slebron Re: I am looking for a... 02-27-2013, 03:47 PM
uxr Re: I am looking for a... 02-27-2013, 03:53 PM
slebron Re: I am looking for a... 02-27-2013, 03:57 PM
daddylonglegs Re: I am looking for a... 02-27-2013, 04:01 PM
slebron Re: I am looking for a... 02-27-2013, 04:13 PM
  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Huntsville. AL
    MS-Off Ver
    Excel 2007
    Posts
    4

    I am looking for a formula in Excel 2007 thta help me determine square footage by room..


  2. #2
    Registered User
    Join Date
    02-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am looking for a formula in Excel 2007 thta help me determine square footage by room

    from what kind of a source data?

  3. #3
    Registered User
    Join Date
    02-27-2013
    Location
    Huntsville. AL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am looking for a formula in Excel 2007 thta help me determine square footage by room

    I am working on a school assignment trying to estimate how much paint will cost base on the sq ft. Example:
    Room: F. Room 25' Length 15' Width and Ceiling Height 12. The SF total is 1335, but I cannot figure the formula.

  4. #4
    Registered User
    Join Date
    02-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am looking for a formula in Excel 2007 thta help me determine square footage by room

    you gotta sum the areas of the walls.
    for this room

    =(2*12*15)+(2*12*25) is the math formula

    room a
    height 12
    Length 15
    width 25
    960

    =2*(B2*B3+B2*B4) is how you find 960 sq. whatever
    this is a math problem, not an excel issue

  5. #5
    Registered User
    Join Date
    02-27-2013
    Location
    Huntsville. AL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am looking for a formula in Excel 2007 thta help me determine square footage by room

    I do understand the math, but how come the Prof. is asking for a formula.

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,698

    Re: I am looking for a formula in Excel 2007 thta help me determine square footage by room

    So if the answer is 1335 you are including the ceiling - for total square footage

    =(L+W)*2*H+(L*W)

    If you have L, W and H in cells you can replace those with cell references
    Audere est facere

  7. #7
    Registered User
    Join Date
    02-27-2013
    Location
    Huntsville. AL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am looking for a formula in Excel 2007 thta help me determine square footage by room

    Thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1