+ Reply to Thread
Results 1 to 3 of 3

If formula issue

  1. #1
    Forum Contributor
    Join Date
    10-28-2003
    Location
    Happyville, USA
    MS-Off Ver
    365
    Posts
    294

    If formula issue

    I'm having a problem with an If formula and I'm not sure exactly what I am doing wrong.

    I am trying to put a formula into C2. If B2 is blank and A2 is not blank I want add 3 to the value of B2. The formula I have is:

    Please Login or Register  to view this content.
    It seems to be this should be working. Any thoughts on what I'm doing wrong?

    Thanks so much in advance.

    Eddie.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,618
    1. You don't need the spaces between the quotation marks. A cell with a "blank space" in it is not an empty cell. A space is an actual character.
    2. If B2 is empty then just enter 3 into C2, no need for the addition.
    3. You need to add an action for the False condition of the IF formula:
    Please Login or Register  to view this content.
    Notice the last set of quotation marks will leave the cell empty if the conditions are not met; otherwise, Excel will put FALSE in the cell.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    10-28-2003
    Location
    Happyville, USA
    MS-Off Ver
    365
    Posts
    294
    Yep, that works. Thanks

+ 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. IF= formula date issue
    By jendew in forum Excel General
    Replies: 13
    Last Post: 05-12-2008, 03:17 PM
  2. How do I subsitute part of a formula linked to another workbook?
    By Scej12 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-03-2007, 10:10 AM
  3. IF/and formula
    By msbing916 in forum Excel General
    Replies: 5
    Last Post: 07-18-2007, 05:58 AM
  4. frequency formula issue - text in source cell
    By redneck joe in forum Excel General
    Replies: 2
    Last Post: 07-13-2007, 08:49 PM
  5. Cell = Formula issue
    By EFGMan in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 01-11-2007, 06:56 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