+ Reply to Thread
Results 1 to 3 of 3

Function problems, please help

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

    Function problems, please help

    Hi

    I'm having a problem with a function that I can't get right.

    I'm currently using the following:

    =IF(E16=F16,"1","0")

    This works fine in that when there is data entered into the cells, I get the correct result I require.

    The problem I'm having is that I need to return a result of "0" when there is no data in cells E16 or F16. At the moment, when the cells are blank, I still get a return of "1".

    Could anyone help please?

    Many thanks

    Mama

  2. #2
    Registered User
    Join Date
    01-18-2004
    Posts
    15
    try

    =if(or(isblank(e16),isblank(f16),e16<>f16),"0","1")

  3. #3
    Registered User
    Join Date
    09-13-2006
    Posts
    2
    PERFECT.

    Thanks 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