How can i convert If statements excel formula to if statements vba code

Good day everyone.

I tried to make macro for my daily job, but i cannot use IF as formula due to so many item in my excel file, so solution is to convert formula to VBA code.

I need help to convert if formula to VBA code in excel as below: =IF(AE2>=0,X2,IF(J2<>J1,AD2,IF(AND(J2=J1,AE1>0),AE1,0)))

I need your help.