Arvi's formula uses the null text string ("") which often has unwanted results if you need to work with those "empty" cells later

There are other solutions without that risk :
use your formula as before and

- conditionally format cells containing a 0 to background color (which is not the best solution)
or

- click File - Options - Advanced - Display options for this worksheet ( change to book if needed) - Uncheck " show a zero in cells that have zero value" (the easiest solution)

or
- custom format cells as 0;-0;;@

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post