Conditional Custom Format

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:

  1. https://stackoverflow.com/a/47784280
  2. https://office-watch.com/2022/singular-plural-text-in-excel/

2 responses to “Conditional Custom Format”

  1. Sandeep Kothari Avatar
    Sandeep Kothari

    Very useful tip.

    Liked by 2 people

    1. Thank you Sandeep 🫶

      Liked by 1 person

Leave a comment

Design a site like this with WordPress.com
Get started