Capture.JPG
Hi Everyone! Based on the picture above, can anyone tell me why the second formula returns #NA when both (right($D$2,4) and ($D$2) return "1024"?
I just couldn't figure out why the second formula won't work?
Note: The two formulas are inserted as Array Formulas.
Bookmarks