| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
