Like the man said - make sure you have a backup (bootable if possible), then go for it.
Personally I've had no issues at all having installed Leopard on 4 machines so far (home and work).... I'd advise against running the regular upgrade process, though - go for an Archive & install which is far less likely to cause problems.