Absolute amount or IF and Greater than Formula Code Required

[Admin]

You could also try this

Range("A2", Range("A" & Rows.Count).End(xlUp)).Offset(, 24).FormulaR1C1 = _
"=IF(abs(RC[11])>1000000,""DISPUTE AMT MISMATCH"",""OK"")"