to clean the cell

[Eric Tsang]

Dear all ,

I am working on a table

We I make a formula to calculate across the row, how can I delete the "null" result

For example : A1:3 has 2 and A4-5 are null, then continue on A6 -8 with 3, all cell to multiply by 3


The result will be , from A 1- 8

6, 6, 6, o, o, 9 , 9 9

How can I delete or avoid the 0

Thanks

[Tony Valko]

One way...

=IFERROR(1/(1/your formula here),"")

[Tony Valko]

Duplicate thread...

https://www.excelforum.com/showthread.php?t=1147085