Results 1 to 8 of 8

OR Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    162

    OR Formula

    Hi,

    I have a spreachsheet that contains postcode data.

    Some of my formulas are:
    :
    In cell C2 =IF(A2="","",OR(I2="CITY",B2="YES"))
    In cell D2 =IF(C2=TRUE,"YES","NO")
    In cell I2 =IF($A2="","",INDEX(DISTRICT,MATCH(Sheet2!A2,POSTCODES,0)))

    I would like the formula in C2 if possible to display directly Yes or No and not True or false so I can delete column D.

    The problem that I seem to have is in cell C2 the or function doesnt work as the value in cell I2 contains a formula and doen't match to my (I2=City). If I type manually in cell I2 the formula and type "City" then the formula correspond.

    Another issue that I have is that In column D once I paste down the formula I would like to leave it blank and not display the value "No" as the cells in column A are blank.

    Another question that I would like to ask is why my file is approx 3MB while it only contains a small amount of data?

    I have attached a copy of my spreadsheet. If you need any additional info please let me know.

    Many thanks
    Attached Files Attached Files
    Last edited by greekboyuk; 05-15-2010 at 04:04 AM.

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