Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keep cell as a date cell
Hi,
My problem is the following (Office Excel 2003): - cell A55 is formatted as a deta-cell and has a formula which says to add 14 days to the date in cell F24; - however, if another cell (D38) is empty/blank, than cell A55 should remain empty/blank. Only if there is information in cell D38, should the date in A55 show up. As soon as I fill in =IF(D380;"(=F24+14)";"") in A55, cell A55 does indeed stay empty as long as nothing is filled in in D38. But with information in D38 cell A55 shows (=F24+14). What is wrong with the formula in A55? Can you help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
keep cell as a date cell
Derk,
iso: =IF(D380;"(=F24+14)";"") try: =IF(D380;F24+14;"") you can't use = in the middle of a formula. you are using quotes..thus your formula will show a (quoted) string, not an evaluated expression. also you'll probably need to format your cell to date format. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam derk wrote : Hi, My problem is the following (Office Excel 2003): - cell A55 is formatted as a deta-cell and has a formula which says to add 14 days to the date in cell F24; - however, if another cell (D38) is empty/blank, than cell A55 should remain empty/blank. Only if there is information in cell D38, should the date in A55 show up. As soon as I fill in =IF(D380;"(=F24+14)";"") in A55, cell A55 does indeed stay empty as long as nothing is filled in in D38. But with information in D38 cell A55 shows (=F24+14). What is wrong with the formula in A55? Can you help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell is blank automatically enter today's date in the same cell | Excel Discussion (Misc queries) | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |