It did the job! Thanks.
Now, one more question....since this formula is being dragged to rows below
and then added at the bottome, I want it to show "0" when neither 0% nor 50%
where selected so that my column total ONLY reflects those variances from 0%
and 50%

Thanks a million!
Carolina

"Mike H" wrote:

Hi,

Maybe this

=IF(L8=50%,E8-M8,IF(L8=0%,H8-M8,0))

Mike

"Carolina" wrote:

I have data in E7 and in H7. Depending on which data they want to go with I
need a formula to make a substration. If they select in L8 that they want the
50% program then in another cell I need the result of E7-M7. If they select
in L8 that they want the 0% program then in another cell I need the result of
H7-M7. No other options available.

My attempt was the following but I got FALSE....I need the differences:
=IF(L8="50%",(E8-M8),IF(L8="0%",(H8-M8),0))

Can you help???

Thanks.
Carolina