+ Reply to Thread
Results 1 to 6 of 6

Formula, Multiple IF Function

  1. 09-28-2018, 11:01 AM #1
    cjpascoe1
    cjpascoe1 is offline
    Registered User
    Join Date
    06-14-2017
    Location
    Detroit
    MS-Off Ver
    2016
    Posts
    7

    Formula, Multiple IF Function

    ['m look for a formula to differntiatethe result of these values, I had originally, "If (Column B is less than A then it puts a Yes or a No if smaller", but if column A has the ** or a dash if still results in it being Yes(Larger) . Any help would be beneifically, I'm looking to not use VBA and need jsut a basic IF or IF(and/or) function to put in column C. Thank you.





    Column A Column B Column C (Larger(Yes), Smaller(No) , -)
    140% Rent Median Rent Formula (result)
    $1,438 $1,369 Yes
    $1,438 $961 Yes
    $800 $820 No
    $1,438 $802 Yes
    ** $1,160 -
    $1,438 $1,220 Yes
    - $1,119 -
    $1,723 $1796 No
    $1,424 $1,196 Yes
    *** $887 -
    $1,806 $841 Yes
    Last edited by cjpascoe1; 09-28-2018 at 11:22 AM.
    Reply With QuoteRegister To Reply
  2. 09-28-2018, 11:14 AM #2
    brant.wheeler
    brant.wheeler is offline
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Formula, Multiple IF Function

    I think this is what you are looking for, but your post wasn't very clear. This formula will return "-" when column A has "**", "Yes" when column A has a higher value than column B, and a "No" otherwise. This formula should be pasted in cell C2 and then copied down.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 09-28-2018, 11:22 AM #3
    cjpascoe1
    cjpascoe1 is offline
    Registered User
    Join Date
    06-14-2017
    Location
    Detroit
    MS-Off Ver
    2016
    Posts
    7

    Re: Formula, Multiple IF Function

    it should be if the text in column a is "**", "***", or "-'", that would return a "-", if there is an actual number then the Less than function would take place
    Reply With QuoteRegister To Reply
  4. 09-28-2018, 11:30 AM #4
    brant.wheeler
    brant.wheeler is offline
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Formula, Multiple IF Function

    Quote Originally Posted by cjpascoe1 View Post
    it should be if the text in column a is "**", "***", or "-'", that would return a "-", if there is an actual number then the Less than function would take place
    This is what it should look like then...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 09-28-2018, 11:32 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Formula, Multiple IF Function

    How about this?

    =IF(AND(ISNUMBER(A2),A2>B2),"Yes",IF(AND(AND(ISNUMBER(A2),A2<B2),"No","-"))

    Testing for the asterisks will throw errors at some point because the asterisk is a wildcard character.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 09-28-2018, 03:56 PM #6
    jtakw
    jtakw is offline
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Formula, Multiple IF Function

    Hi,

    How about this:

    Excel 2016 (Windows) 64 bit
    A
    B
    C
    1
    		 140% Rent Median Rent Result
    2
    1438
    1369
    		 Yes
    3
    1438
    961
    		 Yes
    4
    800
    820
    		 No
    5
    1438
    802
    		 Yes
    6
    		 **
    1160
    		 -
    7
    1438
    1220
    		 Yes
    8
    		 -
    1119
    		 -
    9
    1723
    1796
    		 No
    10
    		 ***
    887
    		 -
    11
    1806
    841
    		 Yes
    Sheet: Sheet85

    Excel 2016 (Windows) 64 bit
    C
    1
    		 Result
    2
    		 =IF(COUNT(A2),IF(A2>B2,"Yes","No"),"-")
    Sheet: Sheet85

    Formula copied down.
    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] Need a workable IFAND function formula for multiple criteria or maybe an Array formula?
    By jeptik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-18-2016, 02:13 PM
  2. [SOLVED] Formula help - multiple conditions for IF function
    By AKD21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2016, 11:52 PM
  3. Multiple Vlookup Normal Formula (not array formula) or VBA Function Required
    By BoopathiK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2015, 03:06 AM
  4. IF function formula with multiple results?
    By media-tel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-28-2014, 11:36 PM
  5. Need formula or function for multiple subtotals.
    By fugee7 in forum Excel General
    Replies: 5
    Last Post: 03-20-2014, 04:57 PM
  6. [SOLVED] Multiple function formula
    By anglarna_ger in forum Excel General
    Replies: 3
    Last Post: 08-16-2009, 11:58 PM
  7. [SOLVED] multiple function in formula
    By Mel B in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-17-2006, 06:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1