Hi,

It is the formating, but I don't know how to fix it?

Using the formula
in H1:
=IF(G20,G2,IF(F20,F2,IF(E20,E2,IF(D20,D2,IF(C2 0,C2,"")))))


if there is data in C1, D1 is preventing that data from showing up in
H1? So if I delete whatever is invisible in D1, it works. I have
tried to just copy the formating from one cell to another but that
doesn't work. So Excel thinks there is something in D1 but it's not
visible.

Thank you.
David