+ Reply to Thread
Results 1 to 2 of 2

IF statement gives wrong answer

Hybrid View

L.LEE IF statement gives wrong... 08-13-2016, 10:16 AM
AlKey Re: IF statement gives wrong... 08-13-2016, 10:23 AM
  1. 08-13-2016, 10:16 AM #1
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    238

    IF statement gives wrong answer

    Hi

    Could you pls let me know why this IF statement gives the wrong answer?

    thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-13-2016, 10:23 AM #2
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: IF statement gives wrong answer

    A1 has a (-14%) negative value. Of course it is lower than 25%.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    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] Array Wrong Answer
    By cocacrave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2015, 06:14 PM
  2. [SOLVED] Formula gives 'wrong' answer.
    By horne in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-03-2014, 01:23 PM
  3. right answer has value 1,wrong answer has value 0
    By zeroist in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2012, 10:45 AM
  4. [SOLVED] Multiplying by 1 gives wrong answer.
    By Garren1013 in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 09:24 AM
  5. right calculation wrong answer
    By allinfernandez in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-06-2012, 10:07 AM
  6. Vlookup giving wrong answer
    By toclare84 in forum Excel General
    Replies: 5
    Last Post: 08-26-2010, 08:53 AM
  7. SUMPRODUCT gives wrong answer
    By DaveBarratt in forum Excel General
    Replies: 4
    Last Post: 10-15-2008, 06:41 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