# Tutoring: Complex Formula Structure Involving the IF Function

1. ## 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.

2. ## 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.

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. ## 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. ## 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.

5. ## Re: Complex Formula Structure Involving the IF Function

Ok, Is there anyway to upload an attachment?

6. ## 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. ## 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. ## 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. ## Re: Complex Formula Structure Involving the IF Function

ok thank you. I will change my title.

10. ## 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)

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

#### 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