Read Range of Excel Formula not as the correct value

[Teck_Hwee_Goh]

Hi there, yes i understand it doesnt read it as formulas but i puzzle why the values it read is not what the formula is suppose to generate. It is generating all as “pending”