New to JET. Havent a clue how to code the following;
If "field1" "NOT NULL" use "Field1" else use "Field2"
Any helpful folks out there care to help a newb out?
K
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi K,
I believe to do this you would just return the values from both fields using 2 different functions (=NF(C2,"Field1") and =NF(C2,"Field2")). Then in a 3rd cell you would use an Excel IF function to return the value in field1 if it was not blank and otherwise return the value in field2. Then you could hide the first two cells by putting "Hide" in row 1 of the same column as their formulas.
Regards,
Hughes
Please sign in to leave a comment.