Help with Validation

[shlomo]

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?

[Dave Peterson]

I don't think I'd use data|validation.

I'd use a cell in a prominent spot.

=if(sum(d:d)>100,"Error in Column D--cannot exceed 100","")

format it in nice big bold red letters.

shlomo wrote:
>
> 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

--

Dave Peterson