+ Reply to Thread
Results 1 to 5 of 5

Need help transferring this logic to simple excel formula

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    NewYork
    MS-Off Ver
    2013
    Posts
    1

    Need help transferring this logic to simple excel formula

    Hello All,

    I am trying to transfer this logic into simple excel and help would be greatly appreciated.

    Thanks,
    Last edited by FDibbins; 09-22-2014 at 05:24 PM.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Need help transferring this logic to simple excel formula

    You're referring to not less than 2.5 different "rules" in the attachment.

    The output for "rules" and the definition for different variables are both left implicit; also there are "recurrence" and "scoring scales" that don't appear to be related to the rest of the definition.

    Can you post a spreadsheet that more clearly defines what explicit output you want?

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Need help transferring this logic to simple excel formula

    The file you have posted is stamped "company confidential". It should not have been posted.
    Ben Van Johnson

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Need help transferring this logic to simple excel formula

    ha ha oh man

    I didn't even notice that until you pointed it out

  5. #5
    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
    52,929

    Re: Need help transferring this logic to simple excel formula

    I have removed that file, it says it is confidential.

    Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    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

+ 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] Simple multiple logic test help
    By rexy69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2014, 11:31 AM
  2. Excel logic formula--HELP!!! Please and Thanks!
    By HillStreet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2013, 01:54 AM
  3. Need Formula for this logic in excel
    By sathyaanil37 in forum Excel General
    Replies: 1
    Last Post: 09-13-2012, 07:20 AM
  4. Need Logic and Formula vb or excel ..
    By mosesy2007 in forum Excel General
    Replies: 3
    Last Post: 02-01-2011, 03:58 AM
  5. [SOLVED] Simple Copy-Paste logic not working
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2005, 02:40 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