The error 504 is caused by the text function. The format specifier, ;"",
is invalid. If what you want is the number with no special format, this
should work.
=IF(G3="";"";TEXT(G3;0))
scsoo wrote:
Dear sir/madam,
I facing the problem to use the formula after convert from Microsoft office
to open office, can you help to change the formula as per below:
Original from Execel:-
=IF(G3=””,””,TEXT(G3,””))
After convert to Open office,
=IF(G3=””;””;TEXT(G3;””))
But , the result show err:504
May I know how to settle this formula.
Please advice
Thanks
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.4/898 - Release Date: 12-Jul-07
4:08 PM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
