+ Reply to Thread
Results 1 to 4 of 4

If(and formulla for two individual data

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Question If(and formulla for two individual data

    Good afternoon all of you
    i want create a formulla for two individual data
    if in first and second column data are between my condition then formulla display yes otherwise not
    =if(and(d2>19,d2<30),"qualify",if(and(e2>19,e2<30),"qualify","not qualify")

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello SANKARTUDU,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    03-05-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: If(and formulla for two individual data

    Yes sir,
    please help me sir

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: If(and formulla for two individual data

    Please post your question in the regular forum. This is for introductions only.

+ 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. Replies: 3
    Last Post: 12-06-2013, 01:25 AM
  2. Formulla If Contains Any Caracters Replace with Space
    By marko737 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2013, 07:19 PM
  3. [SOLVED] Round off formulla
    By anil21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2013, 06:04 AM
  4. how to add a value between sentence.....
    By amruta_shah15 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2012, 01:53 PM
  5. [SOLVED] IF-OR formulla
    By Scott727 in forum Excel General
    Replies: 16
    Last Post: 06-21-2012, 11:34 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