+ Reply to Thread
Results 1 to 2 of 2

inconsistent behavior of a formula

  1. #1
    Registered User
    Join Date
    04-04-2015
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    1

    Question inconsistent behavior of a formula

    the formula is like the following: =if(f2="1","Monday", If(f2="2", "Thursday", if(f2="3", "Peaches", if(f2="4", "pears",F2))))

    some cells return the true value - Monday, Thursday, Peaches, pears or F2
    other cells return the formula - as if it were text.

    If I change the formula in a cell that worked (pears becomes Asteriods), then only the formula is displayed.
    This is excel 2013, any suggestions?

    thanks

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: inconsistent behavior of a formula

    Check the formatting of your formula cells, maybe some of them are formatted as text.
    Also are the numbers 1,2,3 and 4 in the formula entered as Text? Because "1" or "2" and so on will be treated as Text not as numbers.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. Inconsistent textbox and commandbutton behavior at times
    By Joe Tern in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2014, 09:58 AM
  2. Some inconsistent behavior in gathering data from internet
    By dnorris707 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2013, 01:29 AM
  3. newline in cells - inconsistent behavior
    By irwinhorowitz in forum Excel General
    Replies: 0
    Last Post: 04-28-2008, 03:43 PM
  4. Inconsistent Macro Behavior
    By Sarah K in forum Excel General
    Replies: 4
    Last Post: 11-02-2005, 06:17 PM
  5. [SOLVED] Inconsistent macro behavior
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2005, 07:05 PM

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