+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : IF statement with no result when FALSE

  1. #1
    Registered User
    Join Date
    04-27-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    IF statement with no result when FALSE

    Hi,

    I want to write a IF statement as follows-
    =IF($H$4='Current Round '!$B$3,$A5," ")

    My requirement is that when the above condition fails i.e. when condition is FALSE, the outcome should be nothing so that whatever value the cell had earlier, remains in it. To further clarify,
    if condition is TRUE, value of current cell = value in cell A$5.
    When condition is FALSE, value of current cell (e.g. 10) = the existing value of current cell (i.e. 10)

    Please help.


    Thanks and Regards,

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: IF statement with no result when FALSE

    A cell can not contain both formula and constant simultaneously - it's either / or.

    Given the above you need to either a) use VBA or b) use an Iterative formula (ie circular reference) - the latter is generally best avoided.

  3. #3
    Registered User
    Join Date
    04-27-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: IF statement with no result when FALSE

    Thanks a lot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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