add another criteria to an IF formula

[SBLee]

=IF(AE2<=30, J2,IF(AE2>30,V2))
This formula works fine; however, I need it to also be based on column AF=0. I've tried (and , but can't seem to get the sequence correct.

If col AF=0, and AE2<=30, return J2
If col AF=0, and AE2>30, return V2
if col AF isn't = to 0 "conditions"

 

[wigi]

Hello

=IF(AE2<=30, J2,IF(AE2>30,V2)); Your IF is too long. This is the same:

=IF(AE2<=30, J2,V2)

If you want 2 conditions:

=IF(AF2=0, IF(AE2<=30,J2, V2),"conditions")