TripletDad
Board Regular
- Joined
- Oct 19, 2010
- Messages
- 121
The easiest way to explain this is to just say it... please bear with me .
I have a cell (D2) that refers to a previous cell (A2). If A2 says "Yes", then D2 should say return the value of B2+C2. If A2 says "No", the D2 should allow certain values from a predetermined list. Confused yet?
It seems like this is an "IF" statement coupled with Data Validation. Any ideas?
Thank you in advance
-Jeff
I have a cell (D2) that refers to a previous cell (A2). If A2 says "Yes", then D2 should say return the value of B2+C2. If A2 says "No", the D2 should allow certain values from a predetermined list. Confused yet?
It seems like this is an "IF" statement coupled with Data Validation. Any ideas?
Thank you in advance
-Jeff