View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default 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