How do you write a macro with an IF Function

BobBridges · #1 06-04-2013, 10:25 AM

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

CGM3 · #2 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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro or user function to Extract row height	Catalin.B	Excel	12	06-22-2011 09:21 AM
How to write a macro to find a specified name in a list of data?	Jaffa	Excel	1	10-23-2010 02:39 PM
automatic start of macro + help on writing helper function	vsempoux	Word	3	10-09-2009 03:01 AM
Macro or Function to know wether a string is included in a text	Eduardo	Word VBA	5	06-15-2009 01:55 AM
Help! for using an appropriate function/Macro in Excel	pawan2paw	Excel	1	06-04-2009 12:28 PM