Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Need help on OR function

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    245
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i have the following formula:
    =IF(ISBLANK(AF59),0,1)

    i want it to say if AF59 or AE59 or AD59 is blank, return 0, else return 1.

    also, instead of using an OR function and using 10 references to 10 cells, can i use some kind of array that says if AA59 to AG59 is blank, return 0, else return 1?


    thanks in advance.


    mach3

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Milwaukee, WI
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:
    =IF(OR(ISBLANK(A1:A3)),0,1)
    after typing it in, hold down Ctrl+Shift and hit Enter. This will enter it as some sort of array function, and it should work.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-24 08:04, mach3 wrote:
    i have the following formula:
    =IF(ISBLANK(AF59),0,1)

    i want it to say if AF59 or AE59 or AD59 is blank, return 0, else return 1.

    also, instead of using an OR function and using 10 references to 10 cells, can i use some kind of array that says if AA59 to AG59 is blank, return 0, else return 1?


    thanks in advance.


    mach3
    {=IF(OR(ISBLANK(AD59:AF59)),0,1)}

    Note: This is an array formula which is entered using the Control+Shift+Enter key combination. For more on array formulas see the Excel Help Index topic for "About array formulas and how to enter them".

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,074
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-04-24 08:04, mach3 wrote:
    i have the following formula:
    =IF(ISBLANK(AF59),0,1)

    i want it to say if AF59 or AE59 or AD59 is blank, return 0, else return 1.

    also, instead of using an OR function and using 10 references to 10 cells, can i use some kind of array that says if AA59 to AG59 is blank, return 0, else return 1?


    thanks in advance.


    mach3
    If a blank in the range is sufficient to return 0, then use:

    =COUNTBLANK(AA59:AG59)>0)+0

    Amended:

    =CHOOSE((COUNTBLANK(A1:A4)>0)+1,1,0)

    which still allows avoiding an array formula.



    Aladin

    [ This Message was edited by: Aladin Akyurek on 2002-04-24 08:31 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •