+ Reply to Thread
Results 1 to 3 of 3

Nested If Function Problem

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    new york
    MS-Off Ver
    office 365 proplus 1811
    Posts
    13

    Unhappy Nested If Function Problem

    Here I am, back at it again with "IF" function problems.
    For some reason I have ZERO luck with these.

    In Column S, I have the purchase cost.
    In Column T, I have the market value.
    I am trying to nest an IF function.
    If S2=T2, Unchanged.
    If S2>T2, Weak Performance.
    If false, then Good.

    Below is my function. Every time I enter it In excel, I get the pop-up indicating something is wrong with my function. Any edits, suggestions?
    Thx!

    =IF(S9=T9,"Unchanged",=IF(S9>T9,"Weak Performance","Good"))

    Error.PNG
    Last edited by formulacurious; 02-19-2019 at 06:13 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Nested If Function Problem

    You are very close. You have an extra = sign. Try this.

    =IF(S9=T9,"Unchanged",IF(S9>T9,"Weak Performance","Good"))
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-12-2019
    Location
    new york
    MS-Off Ver
    office 365 proplus 1811
    Posts
    13

    Re: Nested If Function Problem

    alansidman .. you are the GOAT. TYSM!!!

+ 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. Problem converting a very simple nested IF function to a UDF
    By GabrielG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2015, 09:53 AM
  2. Problem with Nested IF Function?
    By anasmiff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2014, 10:25 AM
  3. [SOLVED] Problem with using istext in a nested IF function
    By Ciarmccabe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2013, 06:30 PM
  4. nested if function problem
    By headache in forum Excel General
    Replies: 7
    Last Post: 01-10-2007, 06:05 PM
  5. Problem with nested if function. PLS HELP
    By sfar007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2006, 06:34 AM
  6. Replies: 3
    Last Post: 12-11-2005, 01:15 PM
  7. Problem using SUM() function with nested IF()
    By JWeb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2005, 04:04 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