using sysdate in "if" function
 

=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.

using sysdate in "if" function
 

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

using sysdate in "if" function
 

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

using sysdate in "if" function
 

pleased to help you


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539491