+ Reply to Thread
Results 1 to 3 of 3

IF error malfunction in excel 2016

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    malaysia
    Posts
    3

    IF error malfunction in excel 2016

    hi guys,i had a problem with excel 2016.first,i want to set a "yes" and "no" notification with total salaries of 3000 and below.i had use "if" function but it did not work.please help.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: IF error malfunction in excel 2016

    The cells in column E contain text, not numbers.

    Highlight column E
    Tab Data, select Text To Columns.
    Click Next, Next, Finish.

    Your text should now be converted to numbers and your formula will work.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    malaysia
    Posts
    3

    Re: IF error malfunction in excel 2016

    thank you so much.it's help.

+ 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. Compile Error in Excel 2016 [not in 2013]
    By c.davidson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2018, 09:16 AM
  2. Error '438' in Excel 2016 with combo box
    By c.davidson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2018, 09:10 AM
  3. Replies: 4
    Last Post: 03-02-2018, 10:49 AM
  4. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  5. VBA Open FilePath from FTP location - Excel 2016 error
    By mwc360 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2017, 01:34 PM
  6. Excel 2016 Error in Formula or its a bug?
    By pattyyy in forum Excel General
    Replies: 16
    Last Post: 07-18-2016, 12:01 PM
  7. Excel Mac 2016 VBA error, need help
    By BlakeMile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2015, 03:09 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1