Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if([GL_Hierarchy Short Description2]='Profit & Loss A/C's,[GL_Hierarchy Short Description2])
getting error on this point in above statement A/C's, kindly help me to fix this out.
Regards.
Hi,
Try instead
=If([GL_Hierarchy Short Description2] = 'Profit & Loss A/C' & Chr(39) & 's', [GL_Hierarchy Short Description2])
The Chr(39) substitutes the ' character.
Hope that helps.
Miguel
Hi,
Try instead
=If([GL_Hierarchy Short Description2] = 'Profit & Loss A/C' & Chr(39) & 's', [GL_Hierarchy Short Description2])
The Chr(39) substitutes the ' character.
Hope that helps.
Miguel
thnxs Miguel