using sysdate in "if" function

[Avinash]

=IF(N21<="SYSDATE","B","O")

Above is the condition I want to use. But theresult i get is "B" only which
is not true as per the data.

 

[starguy]

try this

IF(N21<=TODAY(),"B","A")

 

[Avinash]

THANK YOU DEAR! IT REALLY SOLVED MY PROBLEM

 

[starguy]

pleased to help you