In a large spreadsheet, one of my formulas is this:

=IF(G318<>"",IF(EXP(Long!I$4*G318)<(2/(Long!I$2+1)),(2/(Long!I$2+1)),IF(EXP(Long!I$4*G318)>1,1,EXP(Long!I$4*G318))),"")
It works 99% of the time, but occasionally the numbers in column G return a NUM error. The formula for column G is much longer than the formula above, so I thought it would be easier to use for my solution.

How do I get a 0 or a "" in column H if column G is #NUM! ?

Thanks!