Problem in my formula :(

[zafielha]

Can you help me to fix this formula?

=ARRAYFORMULA(IF(I4:I="","",IF(I4:I="NA","Finished","Pending")))

I already try what I can do but nothing changes

[crazyforexcel]

Maybe:

=(IF(I4:I="","",IF(I4:I="NA","Finished","Pending")))

CTRL+SHIFT+ENTER to make it an array

[crazyforexcel]

It will help to attach the file so we can test the formula for the application. Point out the expected results please.

Thanks

[zafielha]

It doesn't work, it keep saying #ERROR in google sheet, and #NAME? in excel 2019

[Pete_UK]

It looks like you are using Google sheets, rather than Excel. Why does it need to be an array formula? Put this in the first cell:

=IF(I4="","",IF(I4="NA","Finished","Pending"))

then copy down as far as you need it. Is "NA" the actual string, or do you mean the error #N/A ?

Hope this helps.

Pete