Help - show zero if the word training is in opposite sell?

Hi All,
I am new to the site and looking forward to learn alot.

Issue below,

D6 - Training
E6 - R433
G6 - 75%
I6 - 0%
Formula in J6 =IFERROR(E6*SUM(I6,G6),"-")

The formula above is working fine as is, however if the word 'Training' appears in D6, i need J6 to show the numeral 0.

I hope this explaination is clear, if not, please dont hesitate to reply.

Thanking all in advance.

try this =IFERROR(E6*SUM(I6,G6),)&IF(D6="training",0,"-")

Thank you for the speedy response time "sixthsense" and "globalsourcing"

*Question answered!