=if(C1="VTC",1,"")

with C1 representing the cell with the data validation.

--
Regards,
Tom Ogilvy

"Technician 41706" wrote in
message ...
I copied and pasted it but it has those quotes in it so it doesnt work...
can
you try it without the quotes.... or can you explain what function your
using
and how to plly it

Thank You,

www.cox.net