May I ask for a formula please?
 

I am new to this.

Cell K1 will display the current date, if cell L1 is equal or less than
current date then it will display letter "Y" in cell M1.

Many thanks
Bob

May I ask for a formula please?
 

Hi Bob,

A simple formula to be typed in cell M1 :
=if(L1<=K1,"Y","N")

HTH
Cheers
Carim

May I ask for a formula please?
 

Use the IF function,

=IF(L1<=K1,"Y","N")

if L1 is less than or equal to K1, put a Y in the current cell, otherwise
put an N in the current cell.

Jim

"bob" wrote:

I am new to this.

Cell K1 will display the current date, if cell L1 is equal or less than
current date then it will display letter "Y" in cell M1.

Many thanks
Bob

May I ask for a formula please?
 

bob Wrote:
I am new to this.

Cell K1 will display the current date, if cell L1 is equal or less
than
current date then it will display letter "Y" in cell M1.

Many thanks
Bob

In K1 enter = TODAY()
L1 your date
In M1 enter = IF( L1K1,"","Y")

If you want "N" in M1 if condition is not met then formula for M1 will
be

=IF(L1K1,"N","Y")

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=509333

May I ask for a formula please?
 

many thanks for that


"Carim" wrote in message
oups.com...
Hi Bob,

A simple formula to be typed in cell M1 :
=if(L1<=K1,"Y","N")

HTH
Cheers
Carim