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!

You seem to be missing a piece of information.

You would need to compare the cost savings to the actual cost. For example,
if the cost was $100 and the cost savings was $50 then 50/100 = 50% savings.

This would be easy to plot but what if the savings was, say, 59%? Where
would that fall in your ranges of 100%, 75%, 50%, 25% ?

Also, what if the savings is less than 25% ?

--
Biff
Microsoft Excel MVP


"McDaisyJ" wrote in message
...
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!

Thanks so much! All I have is a printed copy of the spreadsheet so it is
difficult to know what they are computing and how....I'll have to investigate
further.

"T. Valko" wrote:

You seem to be missing a piece of information.

You would need to compare the cost savings to the actual cost. For example,
if the cost was $100 and the cost savings was $50 then 50/100 = 50% savings.

This would be easy to plot but what if the savings was, say, 59%? Where
would that fall in your ranges of 100%, 75%, 50%, 25% ?

Also, what if the savings is less than 25% ?

--
Biff
Microsoft Excel MVP


"McDaisyJ" wrote in message
...
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!