View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Krista
 
Posts: n/a
Default Combining formulas

I can't seem to wrap my head around this. I need to combine the following
two formulas so that the result appears in one cell:

=IF(A33="","",(SUM((2815*30)*A33)))
=IF(A34="","",IF(A34="12x",B34*0.7*0.8,IF(A34="6x" ,B34*0.7*0.5,0)))

Thanks!
--
Krista