Forum Discussion

mithiladas02's avatar
mithiladas02
Icon for Helper I rankHelper I
5 years ago
Solved

Concatenate syntax

Hi,   I am using this  Test=cancatenate(format(divide([a],[b]), "#.0%" & Unichar(10)), (" (" & if [a]=0, "0")& "/" & if ([b]=0, "0",[b])& ")")) using this  syntex i am getting parenthesis for ...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Test=IF(a=0,0,format(divide([a],[b]), "#.0%") & Unichar(10) & "(" & a & "/" & b & ")")

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Test=IF(a=0,0,format(divide([a],[b]), "#.0%") & Unichar(10) & "(" & a & "/" & b & ")")