rrobertson
New Member
- Joined
- Mar 23, 2009
- Messages
- 9
Thanks for reading and any response you can give.
Forgive me for not know all of the jargin but I will do my best.
I was referred to this site from ExcelIsFun on youTube.
I am preparing a new projection form for my sales staff and I've run into a problem. I need to find a way to make the projected number input into a cell change based on the percentage (chance to close) in the adjacent cell.
Basically I want the number to automatically change once it's entered based on the percentage chance to close.
In the adjacent percentage "chance to close" there are only four options 98%, 75%, 50% and 10%.
Now if you have any idea as to how I can fix this, I would greatly appreciate your help.
thanks for any help you can provide!
Forgive me for not know all of the jargin but I will do my best.
I was referred to this site from ExcelIsFun on youTube.
I am preparing a new projection form for my sales staff and I've run into a problem. I need to find a way to make the projected number input into a cell change based on the percentage (chance to close) in the adjacent cell.
Basically I want the number to automatically change once it's entered based on the percentage chance to close.
In the adjacent percentage "chance to close" there are only four options 98%, 75%, 50% and 10%.
Now if you have any idea as to how I can fix this, I would greatly appreciate your help.
thanks for any help you can provide!