Move to next cell if the statement is false return value if true. -- PROBLEM

I need Help!

What formula to be applied to get this? The result would like in column A.


problem.png

in column A it has 6 #N/A's and 4 not #N/A's

in column B I need a formula just to get the not #N/A's in the column A. Starts in to B1 upto B4 only...


Thanks.

Firstly, pictures are of little value. We have no way of knowing what is in the cells. Secondly, many of our forum users cannot see picture attachments and therefore can offer no help. Attach a file by by clicking on the Go Advanced button on the reply screen. Scroll down to Manage attachments and follow the wizard. Now to your question. No idea what you want us to provide you with as you have not provided any criteria for the formula you require. Perhaps you should reevaluate what you want and express it in simple language.