You probably need
=IF(AANTAL.ANS(F5:J5,0)2;"NC";SOM(F5:J5)-MAX(F5:J5))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"RAF JANSSENS"
wrote in message
news:RAF.JANSSENS.1y51hm_1131386103.6551@excelforu m-nospam.com...
gallo
the three "***" are normalie zero's but this wil do
exept that i keep having aan failur message from excel if i past the
line into the colum K
traing to put everithing in dutch
hoping that it wil work then
regards raf
--
RAF JANSSENS
------------------------------------------------------------------------
RAF JANSSENS's Profile:
http://www.excelforum.com/member.php...o&userid=28598
View this thread: http://www.excelforum.com/showthread...hreadid=482646