suppressing N/A sytax error

[lgia]

I have a syntax problem. I have a function that works perfectly below, when the answer is true, I get the number i was looking for, else I get an N/A. I have tried using ISNA, but I can't quite get the syntax right.

=IF(MATCH(planPhase1,TrainingPhase,0)*plantraineehours,plantraineehours,0)

Again the above statement is fine,
I thought the following would work
=IF(ISNA(MATCH(planPhase1,TrainingPhase,0)*plantraineehours,plantraineehours,0),"")

then I tried
=IF(ISNA(MATCH(planPhase1,TrainingPhase,0),"")*plantraineehours,plantraineehours,0)

Can anyone tell me what is the correct placement of the ISNA syntax for this formula

 

[Jonmo1]

Welcome to the board...

You almost had it with the first try, just misplased the ) and ""

Try
=IF(ISNA(MATCH(planPhase1,TrainingPhase,0)*plantraineehours),"",plantraineehours)

 

[lgia]

Thank you!!