Formula Help

  • Thread starter Thread starter Jen Hearns
  • Start date Start date
J

Jen Hearns

Hopefully I can type this clearly enough for you to understand:

I want to make this work somehow in one cell:

if c3=0 & c10=1 then C6+(I6*2)

but

if c3=1 & c10=1, then L2+(I6*2)

How would this work, or is it possible?

Thanks for your help
Jennifer
 
You can nest IF functions

=IF((C3=0)*C10=1,C6+I6*2,IF((C3=1)*(C10=1),L2+I6*2,"neither"))

Jerry
 
Jen
Try this:

=IF(AND(C3=0,C10=1),C6+(I6*2),IF(AND(C3=1,C10=1),L2+(I6*2),""))

If neither option is true, the cell will contain the "" at then end

HTH
Andy
 
=((c3=0)*(c10=1)*(C6+(I6*2)))+((c3=1)*(c10=1)*(L2+(I6*2)))

Without the nested IF's

HTH

PC
 
Back
Top