+ Reply to Thread
Results 1 to 5 of 5

# IF Function

  1. #1
    Registered User
    Join Date
    05-13-2018
    Location
    gURGAON
    MS-Off Ver
    2013
    Posts
    8

    # IF Function

    Dear Team,

    Please find the attached file,
    I have apply the if function but its not find the value properly.

    Regards
    Pankaj
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: # IF Function

    Replace this line
    Please Login or Register  to view this content.
    with this line
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    05-13-2018
    Location
    gURGAON
    MS-Off Ver
    2013
    Posts
    8

    Re: # IF Function

    Hi Yasser,

    Thank you, its working fine.

    But i have one more issue, i want add one more if Score >40 and Name = XYZ then also find Nice other wise bad.

    can we add on this query.

    Regards,
    Pankaj

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: # IF Function

    You can add more conditions by using the operator AND ..

  5. #5
    Registered User
    Join Date
    05-13-2018
    Location
    gURGAON
    MS-Off Ver
    2013
    Posts
    8

    Re: # IF Function

    Quote Originally Posted by YasserKhalil View Post
    You can add more conditions by using the operator AND ..
    Thanks,

+ 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. COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2018, 05:27 AM
  2. [SOLVED] Usage of standard functions into custom function (or user defined function)
    By tusharb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2016, 12:43 AM
  3. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  4. VBA code for custom function that returns detail results of array function
    By onechipshot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2015, 06:30 PM
  5. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  6. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  7. Replies: 1
    Last Post: 03-21-2012, 11:22 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