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

I don't see how you could get a result of FALSE with that formula.

Try it like this:

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

--
Biff
Microsoft Excel MVP


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