If formula results in “”, then that cell will not be empty.
When copy and paste as values, it will not be empty either.
Versus
When we use VBA (Macro command)

Range.value = Range.value

For that “” cell, it will make destination cell as empty.

Sorting table will consider cells with “” as 0, while empty cells are empty and will not be sorted results in order is different