+ Reply to Thread
Results 1 to 3 of 3

Performing a mathematical function on data based on data ID and unique values

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Austin
    MS-Off Ver
    Excel 2007
    Posts
    1

    Performing a mathematical function on data based on data ID and unique values

    Hello,
    I am not an experienced programmer, but trying to learn. I need to write a macro that will perform the function of essentially a big nested IF statement, combining the statements below. In the statements below, the #2 if statement would be pasted in the "Not Ok" spot of the 1st, the 3rd into the 2nd, and so on.

    1. =IF(ISNUMBER(SEARCH("A",E5)),$J$5+(C5/(SQRT(1+$N$5^2))),"Not OK")
    2. =IF(ISNUMBER(SEARCH("H",E5)),$J$7+(C5/(SQRT(1+$N$7^2))),"Not OK")
    3. =IF(ISNUMBER(SEARCH("K",E5)),$J$9+(C5/(SQRT(1+$N$9^2))),"Not OK")
    4. =IF(ISNUMBER(SEARCH("M",E5)),$J$11+(C5/(SQRT(1+$N$11^2))),"Not OK")
    5. =IF(ISNUMBER(SEARCH("O",E5)),$J$13+(C5/(SQRT(1+$N$13^2))),"Not OK")
    6. =IF(ISNUMBER(SEARCH("P",E5)),$J$15+(C5/(SQRT(1+$N$15^2))),"Not OK")
    7. =IF(ISNUMBER(SEARCH("L",E5)),$J$17+(C5/(SQRT(1+$N$17^2))),"Not OK")
    8. =IF(ISNUMBER(SEARCH("N",E5)),$J$19+(C5/(SQRT(1+$N$19^2))),"Not OK")
    9. =IF(ISNUMBER(SEARCH("J",E5)),$J$21+(C5/(SQRT(1+$N$21^2))),"Not OK")

    The excel spreadsheet has about 10K rows. So I would need the results to be displayed in T5, T6, T7...

    Thanks so much in advance for any help.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,053

    Re: Performing a mathematical function on data based on data ID and unique values

    Hi and welcome to the forum

    Not sure you need VBA for this?

    I started on this nested IF() statement, take a look and see if you can finish it?

    =IF(ISERROR(SEARCH("A",E5)),IF(ISERROR(SEARCH("H",E5)),IF(ISERROR(SEARCH("K",E5)),IF(ISERROR(SEARCH("M",E5)),"AA",J11),J9),J7),J5)
    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 Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    13,001

    Re: Performing a mathematical function on data based on data ID and unique values

    I'm not sure exactly what you want but:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

+ 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. Formula to check unique values based on data from 2 columns
    By notsobrilliant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2013, 04:15 PM
  2. Count of unique values based on two columns of data
    By JodyMathis1973 in forum Excel General
    Replies: 8
    Last Post: 04-18-2012, 10:11 AM
  3. Replies: 0
    Last Post: 03-08-2012, 12:18 PM
  4. Create list of Unique values based on Worksheet Data
    By todmac in forum Excel General
    Replies: 3
    Last Post: 02-09-2012, 08:17 PM
  5. Identify row values based on unique data
    By krishnapunekar in forum Excel General
    Replies: 8
    Last Post: 07-01-2010, 12:11 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