+ Reply to Thread
Results 1 to 5 of 5

Nested IF function needed?

  1. #1
    Registered User
    Join Date
    05-23-2016
    Location
    Netherlands
    MS-Off Ver
    Various
    Posts
    3

    Nested IF function needed?

    Hi All,

    Maybe I am making this far too complicated than it should but I cant find what I am looking for.

    I am trying to build a kind of progress indicator and I have attached an example.

    Colomn E - J present a value of 10%
    Colomn K is depending on the value. Bronze 20% and Gold 40%.

    How can I have Colomn M to generate a value based on the input?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Nested IF function needed?

    Paste this formula in M3 and fill down

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    or:-

    Please Login or Register  to view this content.

    Copy one of these formulas and paste it into M3.

    Click on M3 you should see a black square on the bottom right Hand Corner.

    Move your cursor over the square and the cursor will change to a black cross

    Left Click on the square and move the cursor down to M7.

    Release your mouse button.
    Attached Files Attached Files
    Last edited by mehmetcik; 05-23-2016 at 01:07 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    05-23-2016
    Location
    Netherlands
    MS-Off Ver
    Various
    Posts
    3

    Re: Nested IF function needed?

    2 questions..

    A) Can you explain what you are telling me to do?
    B) Can you alter my example file and send it back so I know for sure what you mean?

  4. #4
    Registered User
    Join Date
    05-23-2016
    Location
    Netherlands
    MS-Off Ver
    Various
    Posts
    3

    Re: Nested IF function needed?

    Thank you! I will need to find out how it exactly works but this should help me on my way!

    Edit: Sorry, 1 more question; CountA counts the non-empty cells I just read. How can I do the same but with Values like No=0 and Yes=1 (or a percentage).
    Last edited by Sareno; 05-24-2016 at 10:44 AM.

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Nested IF function needed?

    use countif to count the frequency of a string within a range of cells e.g. =COUNTIF(E3:K3,"YES")

+ 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. (SUM(IF( ARRAY Function with nested LEFT Rule - Help Needed
    By huntethic in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-16-2016, 05:05 PM
  2. Help needed with Nested If Statements.
    By bikerpaul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2016, 07:23 AM
  3. [SOLVED] Help needed for a nested IF function
    By icubud in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2016, 11:59 AM
  4. [SOLVED] Nested IF function needed
    By Petsi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-20-2014, 01:46 PM
  5. Help with Nested IF Formula Needed
    By financeanalyst in forum Excel General
    Replies: 4
    Last Post: 04-03-2014, 10:18 AM
  6. [SOLVED] Nested IF or IF(AND formula needed please
    By rwalker1052 in forum Excel General
    Replies: 3
    Last Post: 11-26-2013, 03:58 AM
  7. Nested IF function (urgent help needed)
    By HJalal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 11:59 AM

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