AND/OR FUNCTIONS

[Guest]

I am trying to write the formula so that If "any" of the fields; (Jan!E2)
through (Dec!E2) are blank I will get the first result; (YTD2005!F12).

The formula below only works if I only use one month that is blank, for
example (Dec!E2). When I try to enter (Jan!E2ec!E2) it returns the last
part of the formula. What am I doing wrong, Please?

=IF(ISBLANK(OR(Jan!E2ec!E2)),YTD
2005!F12,IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(F13)),"",(SUM((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE))))*(360))*(F13))

 

[Guest]

Actually this is the formula that partially works:
=IF(OR(ISBLANK(Dec!E2)),'YTD
2005'!F12,IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(F13)),"",(SUM((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE))))*(360))*(F13))

I had been playing around with the first part of the formula.

 

[Biff]

Hi!

Create a list of your sheet names and give that list a name, something like
SheetNames.

Then use this:

=IF(SUMPRODUCT(COUNTBLANK(INDIRECT("'"&SheetNames&"'!E2")))........................

Biff