Updated

Thanks for reply. In that sheet already D15 contains the formulae. The excel evaluates the formulae & keep the value as 19.95.The default value of that cell is 18.05. When u enter a value which is greater than 95 in C15 it changes the D15 value according to the formulae. I am trying to read that 19.95 through this command.

$cell_data = $worksheet->{cell}[$col_num][$row_num]; # same, unformatted

But its returning 18.05 itself. Not 19.95 which i needed.

Comment on Re^2: Excel-Error reading in formulae value Download Code

Replies are listed 'Best First'.
Re^3: Excel-Error reading in formulae value by poj (Abbot) on Aug 19, 2015 at 06:31 UTC
How does the formulae `=IF(C15>C$13,IF(C15>C$12,C$8,((C15-C$13)(C$8-C$9)/(C$12-C$13))+C$9),IF(C15<C$14,C$10,C$9-((C$13-C15)(C$9-C$10)/(C$13-C$14))))` change with B15 when that cell doesn't appear in the formulae ? poj	[reply] [d/l]