Formula Help

[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

 

[Jerry W. Lewis]

You can nest IF functions

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

Jerry

 

[AndyB]

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

 

[Paul Corrado]

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

Without the nested IF's

HTH

PC