When you pasted the below code, it included line breaks;
you need to remove line breaks as necessary...I believe
you left a break on the first 2 lines...be sure the ":
Exit Function" is on the same line as the "IF" statement.

If datShipDate = 0 Then Bucket = "": Exit Function
If varVal = 0 Then Bucket = "": Exit Function

Rgds,
Allen

-----Original Message-----
Allen,

I tried the custom function you mentioned, however, I am
getting a
Compile Error: Else without If for line 1. Any
suggestions????

Thanks in advance.
.