H
Howard Brazee
K20 looks like this
=IF(ISNUMBER(K19),SUM(C19:K19),"")
When K19 is a formula that displays like a number, the sum displays in
K20, but the cell has a little green triangle in its top left corner.
If I replace K19 with the number displayed, that triangle goes away.
What does that triangle mean? How do I eliminate it?
A large part of my variable sized spread sheets logic is to make
calculations not display anything when there are no data.
=IF(ISNUMBER(K19),SUM(C19:K19),"")
When K19 is a formula that displays like a number, the sum displays in
K20, but the cell has a little green triangle in its top left corner.
If I replace K19 with the number displayed, that triangle goes away.
What does that triangle mean? How do I eliminate it?
A large part of my variable sized spread sheets logic is to make
calculations not display anything when there are no data.