AND/OR FUNCTIONS

B

Bill R

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))
 
B

Bill R

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top