lakeashtonstuff
New Member
- Joined
- Mar 4, 2004
- Messages
- 3
I have three contract types - I can only choose one of the three: CT, CS, or PL
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.
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.