Excel Not "Recognising" Calculated Field From Access

[rob51852]

Hi,

I have a query in Excel imported from Access. It includes a calculated field using the following statement:

IIf(ballsFaced = 0,"", IIf((GrSRAdj<>1),(runs/ballsFaced)*GrBatAveAdj,(runs/ballsFaced))) AS GrAdjSRRpB

When it is imported into Excel the results don't seem to be recognised. They are visible but when I try to use them in formulas they are not being recognised. Equally, if I highlight the cells I don't see the count/sum/average at the bottom of Excel.

Does anyone know what the problem is?

Thanks

 

[RoryA]

I'd guess they are coming through as text due to the "" in the calculation.

 

[rob51852]

Thanks Rory, that was it. Strange because when I simply added two of the cells together (=V3+V4) it worked.

 

[RoryA]

Using an explicit mathematical operator (like * - / +) will make Excel coerce the text into a number if it can (but you'll get an error if it can't). Functions like SUM simply ignore any text arguments, even if they look like numbers.