isna HELP

[Paul T]

Hi

Having a nightmare trying to change the #n/a to 0 {zero}

this is the formula

=IF((AJ4="H")+(AM4="H"),"HH",FALSE)

maybe it's obvious but I could do with a fresh pair of eyes on it.

Many thanks

Paul T

 

[Anne Troy]

=if(and(aj4="h",am4="h"),"hh",0)
*******************
~Anne Troy

www.OfficeArticles.com

 

[Paul T]

Hi Anne

Appreciate the fast response, but unfortunately still getting the same #n/a
?

Regards

Paul T

 

[JE McGimpsey]

If you're getting #N/A with

=IF((AJ4="H")+(AM4="H"),"HH",FALSE)

it's because either AJ4 or AM4 contains #N/A. Perhaps this:

=IF(NOT(ISNA(AK4&AM4)),IF(AK4&AM4="HH","HH"))

 

[Paul T]

Hi

Thank you very much

It worked!!!

I would never of got this in a month of Sundays!

Thanks again

Paul T