Absolute amount or IF and Greater than Formula Code Required

[aaron.mendes]

Hi, need some help here in the below code.

This code throws up a comment 'DISPUTE AMT MISMATCH' when the amt in a particular column is more than 1,000,000 (1million) However, i have amounts that are sometimes in the negative side and still more than a million. For e.g. (-25,000,000 or -5,000,000) and it doesnt populate the comment.

What formula should i apply so that it still throws up the comment 'DISPUTE AMT MISMATCH'?

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

else, can i have an absolute amount as a result of the below code which would automatically make all the amouts positive and then my above code would not require any change.

Range("AF2", Range("AF" & Rows.Count).End(xlUp)).Offset(, 3).FormulaR1C1 = _
"=ABS(RC[-3]-RC[-1])-RC[-19]"

Thanks

[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"")"