CODEWITHSUNDEEP
excelformatting
Regis Santos
Regis Santos

Reputation: 3749

Excel: Format conditional

How to format cell using personal and plural case? I need: 1 unidade or 2 unidades 3 unidades

Singular and plural in the format cell. enter image description here

Upvotes: 0

Views: 77

Answers (1)

Alex K.
Alex K.

Reputation: 175766

Use [=1] to apply a condition & ; to combine with an alternate format string;

 [=1]0 "unidade";0 "unidades"

Upvotes: 3

Related Questions