Conditional Statement With 2 Ands

[sm2200]

How would you write If T12="G" AND U12=1 AND S12>-.00001 then Q13 else 0

Thanks,

Sam Marx







Disregard question on CAN at bottom

 

[MrKowz]

Try:

=IF(AND(T12="G",U12=1,S12>-0.00001),Q13,0)

btw - I know you said to disregard question in your signature, but I can't help but answer it. It does that due to the autocorrect in Excel. If you go into the autocorrect options, you can delete the entry that causes that to happen.