fill diagonal with zero

[lezawang]

Hi
I am just curious, if there is a way to fill diagonal with zeros like below? formula, auto fill kind of things etc. Thank you very much

[TABLE="class: grid, width: 391"]
<colgroup><col><col span="5"></colgroup><tbody>[TR]
[TD][/TD]
[TD]location1[/TD]
[TD]location2[/TD]
[TD]location3[/TD]
[TD]location4[/TD]
[TD]location5[/TD]
[/TR]
[TR]
[TD]location1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]location2[/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]location3[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]location4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]location5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[mrshl9898]

This formula will:

=IF(ROW()=COLUMN(),0,"")