If And Formula

Stephanie Taylor

I want to write a formula that when "Worked ED' is checked and "Job" = BJ then 265 is your answer. What an I doing wrong?

Thank you.

Leibel S

@Stephanie Taylor

=IF(AND([worked ED]@row=1, Job@row="BJ"),265)

Leibel S

@Stephanie Taylor

=IF(AND([worked ED]@row=1, Job@row="BJ"),265)

Stephanie Taylor

Thank you. You've been a big help.