AND/OR FUNCTIONS
 

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!E2:Dec!E2) it returns the last
part of the formula. What am I doing wrong, Please?

=IF(ISBLANK(OR(Jan!E2: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 ))

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.

"Bill R" wrote:

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!E2:Dec!E2) it returns the last
part of the formula. What am I doing wrong, Please?

=IF(ISBLANK(OR(Jan!E2: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 ))

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

"Bill R" wrote in message
...
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!E2:Dec!E2) it returns the last
part of the formula. What am I doing wrong, Please?

=IF(ISBLANK(OR(Jan!E2: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 ))