I knew that Custom Format syntax consists of 4 blocks:
Positive;Negative;Zero;Text
But I didn’t know it can also recognize conditions1:
[condition 1]custom format 1;[condition 2]custom format 2;other number format;text format
See example2 from the GIF:
[=1]0 "day";[>1]0 "days"
Source:
Leave a comment