Results 1 to 4 of 4

Function to work out area of items per roll

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2010
    Location
    los angeles
    MS-Off Ver
    Excel 2008 mac
    Posts
    3

    Function to work out area of items per roll

    I have a window tinting business where i use rolls in 36-48-60-72 inch roll sizes. I am having trouble with a function that returns proper roll sizes. The way it works is:

    If I have a window that is 23X49 I would pick a 48" roll, because 23 rounds to 24 which is half of 48.

    If a window is 60x45 it returns 60.
    If 2 windows are lets say 14x28, then a roll size of 48 will be needed.
    and so on...

    Im having trouble with the equation though, can someone please try to help me. It doesn't work
    Attached Files Attached Files
    Last edited by pike; 07-12-2010 at 12:29 AM. Reason: Help newbie with title pm waring

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