+ Reply to Thread
Results 1 to 3 of 3

Unknow IF condition

  1. #1
    Registered User
    Join Date
    09-01-2006
    Posts
    2

    Unknow IF condition

    Hi,

    I am not sure whether this is the right place for this question.

    I am trying to read a worksheet with if function implemeted.
    =IF(A12="","",).

    Does somebody know what is "","" ?

    Thank you.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    The formula is doing the following

    If cell A12 equals blank "" then return blank "". Some people prefer to replace blank for a 0.

    Also there would usually be another condition like bring back cell A12 value e.g


    =IF(A12="","",A12)

    VBA Noob

  3. #3
    Registered User
    Join Date
    09-01-2006
    Posts
    2
    Oooh, now I understand.

    Thank you very much.

+ 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