I use this formula:

=IF(Sheet2!C5=0;"Sell";"Buy")

if Sheet2!C5 is #N/A I would like the formula to return a blank. Is it
possible ?

Thank you in advance.