If and Greater Than or Absolute Amt 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'?

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

Thanks

[6StringJazzer]

This code will insert a formula that shows the error if the amount is over 1,000,000 or less than -1,000,000.

Please Login or Register  to view this content.