Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Let statement , turning empty cells into 0 ,
so here ;
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Use IF(spill="","",spill).