#NUM! Error in CSE Formula
Posted by Anton on September 12, 2001 12:19 AM
I have a CSE formula that contains a few if statements, that are looking at a query on another sheet called "Data". The formula looks something like this:
The above works fine however when I refresh the query, all the formulas on the first sheet containing the above query show the error #NUM! I have not included field names in the query results, but it still seems to show the same error. Does anyone have an idea on how to prevent this form happening.