#### lakeashtonstuff

##### New Member

- Joined
- Mar 4, 2004

- Messages
- 3

CT is in cell F7

CS is in cell G7

PL is in cell H7

If I choose a CS or PL there are three calculations that will compute

If I choose a CT there is only one calculation that I want to compute

The formula is a forcasting formula for contracts and the date of purchase on the contract.- Which is E7

CS and PL have three calculations they are:

SUM(IF(G7&H7="x",E7+90

SUM(IF(G7&H7="x",E7+180

SUM(IF(G7&H7="x",E7+210

CS has one calculation:

SUM(IF(F7="x",E7+360)

If I choose CS or PL the formula's are producing the correct forcast dates, however, what appears in F7 is a date of 0/01/1900. How do I prevent any results from showing in F7 if I choose a CS or PL.