IF(ISERROR(????)

[Nigel Graham]

Sorry to ask this members but my brain is bursting and I
can not get a function to work.
I have a function which works on its' own
=SUM(C244/(C245*(DATEDIF(C$261,EOMONTH(C$261,0),"D")-(SUMIF
($V$222:$AG$222,C261,$V$230:$AG$230)))))
But when I try to incorportate a IF(ISERROR function it
keeps highlighting the '0' (zero) saying there is an error
in the formula.

=IF(ISERROR((C244/(C245*(DATEDIF(C$261,EOMONTH
(C$261,0),"D")-(SUMIF
($V$222:$AG$222,C261,$V$230:$AG$230))))),0,(C244/(C245*
(DATEDIF(C$261,EOMONTH(C$261,0),"D")-(SUMIF
($V$222:$AG$222,C261,$V$230:$AG$230)))))))

I have looked and looked and can not see the error. I use
this funtion all the time so if there is not data in the
corresponding month it places a zero in its place and is
formatted to show zeros as white text.

C244 = sickness total sickness in month
C245 = Total workforce streangth
Dateif works out how many days in month and multiplies
workforce to give total potential days work in month.
Minus total days leave in month.
V222-AG222 are the leave for each month
C261 is the month is 01/04/03 (UK)
V230 - AG200 is the leave for each of the months.
Without the spreadsheet it is difficult to visualise but
the basic formula works fine.
Help me.................. my brain hurts..........

 

[Paul B]

Nigel, untested but try this,
=IF(ISERROR(SUM(C244/(C245*(DATEDIF(C$261,EOMONTH(C$261,0),"D")-(SUMIF($V$22
2:$AG$222,C261,$V$230:$AG$230)))))),"",SUM(C244/(C245*(DATEDIF(C$261,EOMONTH
(C$261,0),"D")-(SUMIF($V$222:$AG$222,C261,$V$230:$AG$230))))))

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Guest]

Paul thanks for that - you know how it is when you keep
lookng at something and you really need a break away from
the screen and nothing works.

 

[Paul B]

You're welcome, and the feedback is appreciated

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Using Excel 2000 & 97
** remove news from my email address to reply by email **