removing zero's form splll range.

Dicken 186 Reputation points
2026-06-23T15:14:00.27+00:00

Let statement , turning empty cells into 0 ,

so here ;

User's image

so how can i get the = Table version to have empty cells and they are blank i rang an isblank test on original,
i could use if , so IF( spill = 0 , "", spill ) , but i have a 'raeal' zero in oringinal, any suggettions,

i have tried various formats, clearing formats etc.

Richard

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

Answer accepted by question author
Barry Schwarz 6,191 Reputation points
2026-06-23T19:07:15.5533333+00:00

Use IF(spill="","",spill).

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.