+ Reply to Thread
Results 1 to 6 of 6

Square footage formula or VBA

  1. #1
    Registered User
    Join Date
    04-18-2016
    Location
    Georgia, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    3

    Question Square footage formula or VBA

    Hi All,

    is there a way to get the square footage using this data
    Width 8"
    Length 11"
    Sheets Per Roll 250
    Roll Per Carton 2
    SqFt ?


    Thanks,
    Last edited by mkd94; 04-18-2016 at 11:57 AM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Square footage formula or VBA

    What is the size of a sheet?
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    04-18-2016
    Location
    Georgia, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    3

    Re: Square footage formula or VBA

    8"x11" sheet size
    250 Sheets per roll

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Square footage formula or VBA

    Basic multiplication width x length x #sheets per roll x # rolls per carton=total area.

    The only thing I would do, is start by converting your length and width to fractional feet = inches/12
    So 8/12*11/12*250*2
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    04-18-2016
    Location
    Georgia, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    3

    Re: Square footage formula or VBA

    Thank you

  6. #6
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Square footage formula or VBA

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Figure Out Square Footage
    By cloves in forum Excel General
    Replies: 22
    Last Post: 06-23-2020, 04:14 PM
  2. Calculateing Square Footage from dimensions in inches
    By PamelaDefonzo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2015, 03:40 PM
  3. [SOLVED] Formula for Calculating Square Footage
    By mknewnham in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2014, 08:34 AM
  4. Replies: 6
    Last Post: 02-27-2013, 04:13 PM
  5. Replies: 1
    Last Post: 02-27-2013, 03:29 PM
  6. Square Footage of Wall
    By chooge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2013, 08:28 PM
  7. Square footage to board feet conversion
    By RBCC in forum Excel General
    Replies: 2
    Last Post: 12-17-2011, 10:53 PM

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