excel can sometimes be funny with imported data because it formats all your cells as 'text' and then your formulas dont work. select all cells and format as 'general'. the formula will probably still not be working. now double click the cell with the formula in it so your cursor is at the end, and press enter. this will refresh the formula and it should work. then you can copy that formula across to wherever you want it and it should be ok.
