JIS

Examples

• =JIS("A1") returns "A1". JIS stands for Japanese Industrial Standard and this function returns a Japanese string based on the value given. In this example, the value "A1" is given and the function returns the same value.

• =JIS(A2) returns the Japanese equivalent of whatever is in cell A2. For example, if cell A2 contains the text "Hello", the function will return the Japanese equivalent of that text.

• =JIS(B1) returns the Japanese equivalent of whatever is in cell B1. For example, if cell B1 contains the number 7, the function will return the Japanese equivalent of that number.

• =JIS(" ") returns " ". This example shows that the JIS function can also be used to return empty strings. In this example, the function returns two empty spaces, as the value given was two empty spaces.