| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEFT formula
Hello,
Need some assistance on the following: =IF(LEFT(D103,10)=LEFT(E103,10),"1","") D103 is a link to a MS Project file cell containing a date and time - eg. "13/09/2010 11:00:00 AM". E103 is a date - eg. "13/09/2010". The above formula should produce "1" when the first 10 characters match. How ever it does not. Can any one see my error or offer a better formula to get the result I am after? Thanks for your help in advance. Ant. -- Cheers Ant. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when inserting new worksheets they read right to left not left to. | Setting up and Configuration of Excel | |||
| if(or(left Formula | Excel Discussion (Misc queries) | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
| Question about using the right or left formula | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
Threaded Mode
