HOW CAN I FIXED FORMULA THAT DISPLAYS #NA

[Roger Govier]

Hi

try
=IF(ISNA(your_formula),"",your_formula)

 

[Dave Peterson]

=if(isna(yourformula),"",yourformula)

Maybe????



mjb475 wrote: