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" wrote:

>
> try this
>
> IF(N21<=TODAY(),"B","A")
>
>
> --
> starguy
> ------------------------------------------------------------------------
> starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
> View this thread: http://www.excelforum.com/showthread...hreadid=539491
>
>

[starguy]

pleased to help you