+ Reply to Thread
Results 1 to 10 of 10

Tutoring: Complex Formula Structure Involving the IF Function

  1. #1
    Registered User
    Join Date
    03-12-2015
    Location
    Canada
    MS-Off Ver
    2007/2013
    Posts
    6

    Tutoring: Complex Formula Structure Involving the IF Function

    How would I structure the formula for this problem?
    The wages for YoYo Joe’s will increase if the number of items sold each month exceed 25500. The calculation
    of wages includes a fixed base amount of $175000 plus an increase of Excess_Production_Cost per 1000
    units over (rounded to the nearest 1000). In order to calculate this amount, both the IF function and Round
    function must be used. If the number of units (widget units and gadget units) exceed 25000, then the wages
    are equal to the number of units over 25,000 rounded to the nearest 1000 (precision is -3) times the
    Excess_Production_Cost assumption plus $175000 – otherwise it is just the $175000.

    This is the formula I have been trying: =IF(SUM(B9+B10)>25000,ROUND(COUNT(SUM(B9+B10)>25000),)+175000,175000)
    I have attached the worksheet that I a working with.
    Attached Files Attached Files
    Last edited by lila12; 03-12-2015 at 11:34 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: I need help with this formula structure ASAP please!

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Registered User
    Join Date
    03-12-2015
    Location
    Canada
    MS-Off Ver
    2007/2013
    Posts
    6

    Re: I need help with this formula structure ASAP please!

    So sorry, I just joined, now I will remember not to do that next time! Thanks

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,626

    Re: Complex Formula Structure Involving the IF Function

    If you post a workbook with some sample data and the expected results it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  5. #5
    Registered User
    Join Date
    03-12-2015
    Location
    Canada
    MS-Off Ver
    2007/2013
    Posts
    6

    Re: Complex Formula Structure Involving the IF Function

    Ok, Is there anyway to upload an attachment?

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: Complex Formula Structure Involving the IF Function

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  7. #7
    Registered User
    Join Date
    03-12-2015
    Location
    Canada
    MS-Off Ver
    2007/2013
    Posts
    6

    Re: Complex Formula Structure Involving the IF Function

    Project3-Q1 .xlsxCOSC1702-W15-Project3.pdf

    I attached the starter data and the page that gives the actual question. It's step 9 on question 1. I don't know how to structure the formula for this step. Thank you.

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: Complex Formula Structure Involving the IF Function

    Nothing is more frustrating than to be working on homework and to get stuck.

    Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

  9. #9
    Registered User
    Join Date
    03-12-2015
    Location
    Canada
    MS-Off Ver
    2007/2013
    Posts
    6

    Re: Complex Formula Structure Involving the IF Function

    ok thank you. I will change my title.

  10. #10
    Registered User
    Join Date
    03-12-2015
    Location
    Canada
    MS-Off Ver
    2007/2013
    Posts
    6

    Re: Complex Formula Structure Involving the IF Function

    And this is the formula I have been trying : =IF(SUM(B9+B10)>25000,ROUND(COUNT(SUM(B9+B10)>25000),)+175000,175000)

+ 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. HELP REQ ASAP on match formula
    By m_789 in forum Excel General
    Replies: 3
    Last Post: 05-04-2014, 06:48 AM
  2. Creating a Pyramid Hierarchy structure from a flat structure
    By thegamerulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2014, 01:28 AM
  3. ASAP in an On-Time Formula
    By Jeronimo9999 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2008, 12:58 PM
  4. [SOLVED] Need a Formula ASAP
    By Korie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-06-2005, 12:05 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