I know it's doable with the validation function.

I wont that the total of column D should not be able to be more then
100.
what do I have to enter in the validation function?


--
shlomo
------------------------------------------------------------------------
shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304
View this thread: http://www.excelforum.com/showthread...hreadid=345568