+ Reply to Thread
Results 1 to 5 of 5

Nested IF formula with multiple calculations as outputs?

  1. #1
    Registered User
    Join Date
    01-16-2017
    Location
    Valencia, Spain
    MS-Off Ver
    2013
    Posts
    3

    Question Nested IF formula with multiple calculations as outputs?

    Hello all - this is my first post. I'm sorry if I don't know what I'm saying - it's because I'm not 100% sure of what I need to use in a formula to achieve my goal. Let me explain. I am a translator and editor. As part of starting with a clean slate in 2017 I've decided to try to further hone my ability to predict how much time I will require for different types of job.

    I have broadly two types of regular work coming in: copyediting and translation. Editing usually takes me about half the time but it depends on the complexity of the task. Within each category, there are different levels of difficulty and therefore, time required to do a job. I realized that I could categorize these (as I already do for billing purposes) as essentially, and for my purposes, "Easy/Medium/Hard".

    Having looked at some past numbers (I still need to do an in-depth analysis) and doing some back-of-envelope calculations I realized I could base my daily productivity on the number of words I can process for each category whilst also factoring in all the other stuff I do for my business (not directly related to actually processing words + brain-rest time).

    I came up with the following codes for Copyediting and Translations:

    CE1 = 962 words/hour or 4810 words/day
    CE2 = 811 w/h or 4055 w/d
    CE3 = 685 w/h or 3425 w/d

    Tx1 = 642 w/h or 3210 w/d
    Tx2 = 550 w/h or 2750 w/d
    Tx3 = 208 w/h or 1040 w/d

    I want to be able to plug these numbers into excel, combining them with the word count for each job that comes in to give me an estimate preferably in days/hours/minutes of the estimated time I will need to do each task. Currently, I am very bad at appreciating this based on the excel tables in front of me so an actual number would be a great start. It would help me with customer quotes and deadline planning, and to know when I might need to out-source work, which I am also really bad at noticing. I like this idea because it means I can tweak the figures as necessary over time, and perhaps even add in extras as necessary.

    A very simplified version of my current work management template looks a bit like this, where the "service" refers to the speed at which the customer requires their work be returned:

    A1 A2 A3 A4 A5
    1 Project Ref: Service: Code: Words: Estimated Time Required:
    2 Cactus Book 2 months Tx2 32482 dd:hh:mm
    3 Active commuting to preschool 7 days CE2 3311 dd:hh:mm
    4 Real Estate Descriptions January 24 hours Tx1 781 dd:hh:mm
    5 The Dark side of cultural policy 4 days Tx3 2402 dd:hh:mm

    I'm looking for the way to fill in the dd:hh:mm section automatically via a formula(s).

    As an added bonus, if anyone has any idea how I might be able to graphically display this is it a Gantt chart? or something similar I will personally purchase the internet for you and deliver it to your door in person, with flowers, and a card! hahaha! :')

    I apologize for this long and winding post, but I don't know what I need or what to call it, or how to solve this problem which is becoming ever more important as my business grows. I hope you are willing and able to help or point me in the right direction! I have tried to be detailed to avoid misunderstandings and confusions!

    Best wishes to all.
    Maria

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,107

    Re: Nested IF formula with multiple calculations as outputs?

    Welcome to the forum!

    Unfortunately your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    01-16-2017
    Location
    Valencia, Spain
    MS-Off Ver
    2013
    Posts
    3

    Re: Nested IF formula with multiple calculations as outputs?

    Oh, sorry!

    I have also posted this on Excel Guru.ca at the following link: http://www.excelguru.ca/forums/showt...riable-outputs

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,184

    Re: Nested IF formula with multiple calculations as outputs?

    So why, if you had posted it and received two responses on 14 January did you post here?

    Did neither of the responses on the other forum cut the mustard?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    01-16-2017
    Location
    Valencia, Spain
    MS-Off Ver
    2013
    Posts
    3

    Re: Nested IF formula with multiple calculations as outputs?

    I'm sorry - I have only just seen the responses today, after receiving the notification from AliGW. For some reason I did not receive receive any notifications about it (I had previously not received a registration email from them and had to contact the administrator to address that).

    Given that I posted to this forum after the fact (in the incorrect assumption that nobody on the other site had replied) and then found I had recieved some help, I assumed that somebody may be looking at it here so I thought it better to post the corss-link here rather than delete altogether, in the interest of sharing information.

    I'm sorry if I have upset anyone. I'd be happy to delete it if that makes the forum clearer for future users.

    Best wishes.
    Maria

+ 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] Nested IF with multiple calculations
    By KIMMEYER in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-25-2016, 12:22 PM
  2. [SOLVED] Evaluating a formula for multiple inputs and getting multiple outputs
    By BREOL in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-17-2016, 02:11 AM
  3. Formula checks multiple cells for words and outputs answer depending on cells
    By keez1993 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2015, 09:18 AM
  4. Nested what if formula with some calculations
    By raperm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-05-2013, 02:44 PM
  5. Nested formula with some greaterthan/less than calculations
    By raperm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2013, 03:51 PM
  6. how to get colored outputs from a nested IF function
    By dsklein85 in forum Excel General
    Replies: 3
    Last Post: 01-16-2012, 11:11 AM
  7. Nested logic to get 6 outputs from 3x2 matrix of inputs
    By andysurtees in forum Excel General
    Replies: 5
    Last Post: 02-15-2009, 09:09 PM

Tags for this Thread

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