You've currently got the number 0 as the result if the input is neither 50%
nor 0%. If you really want the text string "0" instead, put the zero at the
end of the formula in quotes, but you need to be careful how you do further
arithmetic, as many arithmetic operations will give #VALUE! errors if you
feed them with text inputs.
--
David Biddulph


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