keep cell as a date cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(D38>0;"(=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?
 
Derk,

iso: =IF(D38>0;"(=F24+14)";"")
try: =IF(D38>0;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 :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with ranges 7
Help with a formula I am editing 5
How to stop index match returning data where lookup cell empty 4
MAX in VBA not working 5
Eliminate formula Query 3
if(isna(match formula 8
Need to get value of last number in a column 2
Link from Userform to Spreadsheet 3

Back
Top