+ Reply to Thread
Results 1 to 3 of 3

HELP Using the =if formula (or a more suitable one for my needs).

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    HELP Using the =if formula (or a more suitable one for my needs).

    Good Afternoon all.

    I have an excel document I use for my shops sales projections. To help me do my rosters each day.

    The file 7 tabs for each day, each tab has 4 columns.

    The first is the time in 30 minute intervals (6am, 6.30am, 7am, etc - Never changes)

    The second is the projected sale I project to do in the 1/2 hour time frame ($80, $130, $310). I type this in manually each day when looking at yesterday, last week and last years sales.

    The third column is an accumulated sales column from open until that time (easy formula =sum(B1-B2) =sum(B1-B4)

    COLUMN 4 - THE TRICKY ONE, The forth column is the number of crew I should have on for that half an hour period.
    Sales $0 to $100 = 2 employees
    Sales $100 to $200 = 3 employees
    and so on . .

    At the moment I have to manual type it out the number of crew but I want to put in a formula which works it out for me.
    something along the lines of if B1 is between 0-100 D1 = 2, if B1 is between 101-200 D1=3, if B1 is between 201-300 D1 =4 all the way up to 9 crew.

    Help please???


    Thanks in advanced

    Tom

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: HELP Using the =if formula (or a more suitable one for my needs).

    Hi and welcome to the forum

    If your sales are in A1 down, try this in B1, copied down...
    =1+(MROUND(A1,100)/100)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Re: HELP Using the =if formula (or a more suitable one for my needs).

    Hi Tom,

    Try this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    -------------
    Tony

+ 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] What is the suitable formula if getting error: #VALUE!
    By umais41 in forum Excel General
    Replies: 4
    Last Post: 12-31-2012, 03:19 PM
  2. Looking for A Suitable Formula for My Spreadsheet To Find Exact Matches of Data
    By Lynda Ritchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2012, 09:22 AM
  3. Replies: 3
    Last Post: 03-29-2010, 10:07 PM
  4. A suitable function
    By marleine in forum Excel General
    Replies: 2
    Last Post: 05-26-2009, 07:48 AM
  5. Is V-Lookup suitable
    By Prium in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2008, 04:56 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