+ Reply to Thread
Results 1 to 4 of 4

Having problems with these 2 questions IF, And statements

Hybrid View

  1. 03-10-2015, 10:38 PM #1
    Miscninja
    Miscninja is offline
    Registered User
    Join Date
    02-15-2015
    Location
    Unites states, Louisville
    MS-Off Ver
    2012 excel
    Posts
    4

    Having problems with these 2 questions IF, And statements

    Screenshot_1.pngScreenshot_2.png

    =and(c2=25,d2=25)"TRUE"
    =or(b2>2,c2=2)"TRUE"

    i was wondering if these would work
    Last edited by Miscninja; 03-10-2015 at 10:48 PM.
    Reply With QuoteRegister To Reply
  2. 03-10-2015, 10:45 PM #2
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Having problems with these 2 questions IF, And statements

    without the "TRUE" at the end
    like below

    =and(c2=25,d2=25)
    =or(b2>2,c2=2)
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  3. 03-10-2015, 10:47 PM #3
    Miscninja
    Miscninja is offline
    Registered User
    Join Date
    02-15-2015
    Location
    Unites states, Louisville
    MS-Off Ver
    2012 excel
    Posts
    4

    Re: Having problems with these 2 questions IF, And statements

    thanks the last one had my kinda worried because the true was in string form
    Reply With QuoteRegister To Reply
  4. 03-10-2015, 11:04 PM #4
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Having problems with these 2 questions IF, And statements

    =IF(AND(C2=25,D2=25),"true","false")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Textbox formatting questions/problems
    By Jay T in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-11-2013, 09:59 PM
  2. Questions about netsing IF Statements
    By mussussu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2013, 04:26 PM
  3. questions with if statements and nested if statements
    By Pat Excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-03-2013, 01:41 PM
  4. Problems with 'If... Then' statements
    By KyleKaplan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-07-2011, 12:02 PM
  5. Sumifs Questions - Multiple Statements
    By WorkMan in forum Excel General
    Replies: 2
    Last Post: 11-26-2009, 08:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1