I dont want the formula but the values that is calculated by the formula in excel. For eg I have something like this: A B C 1 1/2/13 yes =IF(AND(A1 <> ".",B1 <>""),"YES","NO") 2 2/3/12 No =IF(AND(A2 <> ".",B2 <>""),"YES","NO") 3 4/5/14 Yes =IF(AND(A3 <> ".",B 3<>""),"YES","NO") So I want to import the data with the values calculated by the formula in C which is just yes,no and yes... and I have to use the excel file in XLSX format with multiple sheets
... View more