I have never had any issues with viruses using Norton Anti Virus for Mac.
That's kind of like saying that you've never had any problems with alien mind-control since donning your tin-foil hat. Since there aren't any viruses for the Mac at this time, you wouldn't have had issues with them
without Norton either.
Contrary to what many like to admit, there are trojans that affect the Mac, and there are more than three of them. There was a link to my [Mac Virus guide|http://www.reedcorner.net/thomas/guides/macvirus> earlier in this thread, and you'll find there [a list of all the trojans I'm aware of|http://www.reedcorner.net/thomas/guides/macvirus/malware_catalog.shtml]. (Note that some anti-virus vendors will list other trojans, which are, AFAIK, simply their own name for the same trojans. AV companies all seem to like to claim "first discovery" and thus apply their own name to things, so trojans often end up with multiple names.)
However, none of these are particularly threatening if you use some common sense and think about what you're downloading and what you're giving your admin password to.
It has detected one or two viruses in the past
Most likely those were just Windows viruses attached to e-mails or copied over some other way from a PC. That sort of thing happens with great frequency, but of course you're never told by your AV software that the virus that was found can't possibly infect your machine.