Custom function in VBE

Giganews Newsgroups
Subject: Custom function in VBE
Posted by:  mary s
Date: Tue, 16 May 2006

I'm trying to write a custom function in VBE to determine if my data falls
into one of three categories, active, inactive, or future, for functions that
I use all the time in multiple workbooks.  The HELP in Excel isn't much help
for something so complex.

Here is a stripped down example of my function:
=IF(OR(D2="2",D2="3",D2="4"),"Active",IF(OR(D2="5",D2="6"DK2="7",D2="8"),"Inactive",IF(OR(D2="9",D2="10",D2="11"),"Future")))

Any tips on how to get started are much appreciated!

Replies