There are a couple of ways to create formulas like this. Start the formula with an sign select a cell enter an operator like or then select another cell. Use the equal sign to calculate.
Start typing the formula by typing the equals sign then click on the name of the other worksheet.
Now Type the equal symbol. Method 2 - Percentage Formatting Through the Format Cells Dialog Box. Now apply the formula for a percentage as discussed above and as shown in the below picture. To add use the sign.