Cell with formula remains blank
Good afternoon, I have entered a formula in a cell and converted it to a column formula. All cells in the column populated the desired data based on the formula except for the original cell. The original cell is blank. When I right click the cell and select "edit formula" the formula appears. I have checked all text formatting and everything seems to be in order, but I cannot figure out why the cell remains blank.
Right click cell and select edit formula
Any help would be appreciated.
Thank you,
Mandy
Answers
-
Have you tried cutting the value from a YTD Total Score from a row that is working and pasting that in the row that is not working?
-
Hi mattstoc,
Yes, I have moved the data to different rows, different columns and even attempted the same formula in a different sheet. The same issue happened. I also deleted another reps name and re-added just to see if it would happen to a different name. I could not repeat the error for any other rep.
Thank you,
Mandy
