#NAME? error in aging calculations
Hi Claudia,
Am Sun, 7 Dec 2014 19:09:46 +0000 schrieb Claudia Faust:
=IF((L5+M5=1),(NETWORKDAYS,A1,C5),(NETWORKDAYS,I5, C5))
you have no brackets round the function NETWORKDAYS.
Try:
=IF(L5+M5=1,NETWORKDAYS(A1,C5),NETWORKDAYS(I5,C5))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|