I'm a dummy when it comes to complex formulas....
I have 5 columns - costs savings, 100%, 75%, 50%, 25%. I have a dollar
amount in the cost savings column. If the initiative is 100% probable, I want
to put an "X" in the 100% column, 75% probable, then an "X" in the 75%
column. I then want the percent columns to sum (I can do that formula!).
What formula do I put in the percent columns?
Thanks so much!