Forum Discussion
Solved
Alert in Excel charts
Hi, could you help me to correct the following formula which I try to create: =JEŻELI(G2>DZIŚ;[OK];[LATE]). Formula is in Polish version ('JEŻELI' = 'IF', 'DZIŚ' = 'TODAY'). The idea is to have an al...
DZIŚ is a function, so you should use DZIŚ().
And text strings should be enclosed in double quotes ".
=JEŻELI(G2>DZIŚ();"OK";"LATE")
Select the range with these formulas.
I don't have a Mac, so I cannot help you with the conditional formatting.
DZIŚ is a function, so you should use DZIŚ().
And text strings should be enclosed in double quotes ".
=JEŻELI(G2>DZIŚ();"OK";"LATE")
Select the range with these formulas.
I don't have a Mac, so I cannot help you with the conditional formatting.