IF(ISERROR(????)

  • Thread starter Thread starter Nigel Graham
  • Start date Start date
N

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..........
 
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 **
 
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.
 
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 **
 
Back
Top