ExcelBanter - HOW CAN I FIXED FORMULA THAT DISPLAYS #NA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW CAN I FIXED FORMULA THAT DISPLAYS #NA (https://www.excelbanter.com/excel-worksheet-functions/92515-how-can-i-fixed-formula-displays-na.html)

mjb475

HOW CAN I FIXED FORMULA THAT DISPLAYS #NA

Roger Govier

HOW CAN I FIXED FORMULA THAT DISPLAYS #NA

Hi

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

--
Regards

Roger Govier

"mjb475" wrote in message
...

Dave Peterson

HOW CAN I FIXED FORMULA THAT DISPLAYS #NA

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

Maybe????

mjb475 wrote:

--

Dave Peterson

All times are GMT +1. The time now is 01:10 AM.