Multiple Conditions
=IF(D7="12x",E7*0.7*0.8,IF(D7="6x",E7*0.7*0.5))
or
=IF(D7="12x",E7*0.56,IF(D7="6x",E7*0.35,0))
which returns 0 if not 12x or 6x
HTH
"Krista" wrote:
Hi!
I'm fairly new to complex calculations and am trying to setup a spreadsheet
with a lot of variables and need some help. Here's one incorrect calc that I
need help with: =IF(D7="12x",((E7*0.7)*0.8)),IF(D7="6x",((E7*0.7)* 0.5))
I'm trying to do the following in one calcuation:
If D7 = "12x" then multiple E7 by .7 then that number by .8. But if D7 =
"6x" then multiple E7 by .7 then that number by .5.
Thanks in advance for any suggestions.
--
Krista
|