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(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