in reply to Re: how to enter formula in excel
in thread how to enter formula in excel

Or rather:

$Sheet->Cells(3,1)->{Value} = q/=IF(A1=B1,"PASS","FAIL")/;

Please don't ever actually write a string in Perl with escaped embedded quotes.

In Section Seekers of Perl Wisdom