This is probably very basic. But any formula shows in the cell and displays nothing other than the formula itself. It's as if I had a ' in front of the = (I don't).
So it'll say =sum(a1:a4) instead of giving me the answer. Same with LEN and VLOOKUP.
I have cell formatting as General (I've tried changing to number and no change).
What am I missing?
So it'll say =sum(a1:a4) instead of giving me the answer. Same with LEN and VLOOKUP.
I have cell formatting as General (I've tried changing to number and no change).
What am I missing?