Thanks:  0
Likes:  0

# Thread: Need help on OR function

1. 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?

mach3

2. 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. 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?

mach3

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. 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?

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.

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

## User Tag List

#### Posting Permissions

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