Microsoft Office Forums - View Single Post - How do you write a macro with an IF Function

CGM3 · 06-05-2013, 05:32 AM

Quote:

Originally Posted by BobBridges

Normally, yes, CGM3. But I looked at the sample workbook; purchases are negative and sales are positive, so it's the other way around.

So use:

If Balance < ABS(XctAmt) Then

(Has the advantage of implying, for the unfamiliar user, that XctAmt might be negative)