31 x 6 186. So 40 would be 40 divided by 100 or40. Enter an asterisk.
31 x 6 186.
The result is shown as 016 because cell C2 is not formatted as a percentage. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. If we have to calculate percent of a number divide the number by whole and multiply by 100. Multiply it by 6 to find 6.