This function allows characters to be referenced by their ASCII decimal code. This is useful for when characters, such as the copyright symbol ‘©’, are not readily available on the keyboard.
chr( v )
v - The ASCII decimal code of the required character or symbol.
Insert a copyright symbol ‘©’: The ASCII decimal code for the ‘©’ symbol is 169.
Used within an IIF function
The following iif() statement compares the answer value of another question to a fixed string.
The formula returns a ‘£’ symbol if the value is ‘GBP’ otherwise it returns a ‘$’ symbol.
ASCII comma in concat
join concat format style text iif comma symbols symbol character first firstname surname currency equal