Need help on OR function

[mach3]

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

[jrnyman]

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.

[Mark W.]

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

[Aladin Akyurek]

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 ]