VBA to analyse

Hello,

I am not sure if it can be done.. But what I am trying here is noted below.

1. I have string of data in Column N and Column O
2. If in Cell of Column N and Column O of same row has value #N/A, then I need adjustment cell P noted with " not available "
3. If in any one Cell of Column N and Column O of same row has value #N/A, then I need VBA to do noting.
4. If in both Cell of Column N and Column O of same row do not have value #N/A, then I need VBA to do nothing.?

My header start from Row 5.

Can it be done?

Cross Posting

HTML Code: 

Thanks

How about just a formula?

=if(and(isna(n2), isna(o2)), "not available", "")

Formula works, but can we tweak that into VBA??

Thanks

Finally i was able to get it done.

Please Login or Register  to view this content.

Thanks shg.

Hi Sgh,

I want to extend your formula to another cell at the left..

Please Login or Register  to view this content.

Whats wrong with the code?

Thanks

Please Login or Register  to view this content.

thanks! Solved.