Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Coding - any ideas why this UDFs not working?
Function MyStatus(Status1 As Variant, Status2 As Variant) If (Status1 = "n/a") And (Status2 = "n/a") Then Result = "Authorised" Else If (Status1 = "n/a") And (Status2 < " ") Then Result = "Misc" Else If (Status1 = "Pending") And (Status2 = "n/a") Then Result = "Pending" Else If (Status1 = "Waiting Auth") And (Status2 = "n/a") Then Result = "Pending" End If End If End If End If Result = MyStatus End Function Mystatus invloved status1 and status2, which are lookup into different sheets, basically if the lookup is #n/a then it brings back "n/a" The result is coming back 0?? Any ideas? Thanks. -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=475038 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the grab and drag function isn't working in excel any ideas? | Excel Discussion (Misc queries) | |||
Help and description for UDFs | Excel Worksheet Functions | |||
UDFs | Excel Programming | |||
=ROW-1 modified coding in filters not working in Excel 2002. | Excel Programming | |||
Acrobat 6.0 and UDFs | Excel Programming |