| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Joining String with function in IF()?
A B 1 $100 =IF(NOT(ISBLANK(A1)), "Deposited on" + NOW()) Can I join a string like "Deposited on" with a function like above? I wanted to make it auto update on the date when I key in $100. Why does =IF(NOT(ISBLANK(A1)),NOW()) shows 38563.68864? I can't get the date out.Pls help -- Lewis Koh ------------------------------------------------------------------------ Lewis Koh's Profile: http://www.excelforum.com/member.php...o&userid=25712 View this thread: http://www.excelforum.com/showthread...hreadid=391511 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Threaded Mode
