Hi all,

I am helping a friend calculate some data using imported data (I am not sure where from) and the table may look as below.

---col A-----col B-----col C
11-------------10--------12

I am using if(and(A1<20,B1<20),C1*10

This should give me an answer of 120 but I get a FALSE statement return.

Col A and Col B although both numbers seem to be behaving differently.

The numbers in col A are to the far left of the column, all other column numbers are to the right.

If I actually type 11 into A1 the formula works ok.

I have tried formatting and pre-formatting the columns to no avail.

Is it something to do with the data being imported and is ther any way around it.

Thanks as always.

Greg.