questions aboaut excel functions

Question

&nbsp;

hansvogelaar · Answer

taroda385&nbsp;
Change the formula in D3 to
&nbsp;
=IF(C3="";"";C3+14)
&nbsp;
and that in E3 to
&nbsp;
=IF(C3="";"";IF(TODAY()&gt;=D3;"Finish Quarantine";"Quarantine"))

taroda385 · Answer

HansVogelaar&nbsp;thank you for your answerOne more questioncan it be used in excel condittional formatting.?how is the formula?thank you

hansvogelaar · Answer

taroda385&nbsp;
&nbsp;
A conditional formatting formula must return TRUE or FALSE. For example:
&nbsp;
=AND($C3&lt;&gt;"",TODAY()&gt;=$D3)

taroda385 · Answer

HansVogelaarThank You very much&nbsp;&nbsp;

detlef_lewin · Answer

HansVogelaar&nbsp;A conditional formatting formula must return TRUE or FALSE. For example:Not quite.In order to trigger the conditional formatting the formula must return TRUE or a number value not equal to 0.If the formula returns text, an error value, 0 or FALSE the conditional formatting will not be triggered.

Forum Discussion

questions aboaut excel functions

8 Replies

Resources