Formatting to Display Percentages in Excel Cells. 100 - 9 91 is what you need to get back to 100 In probability theory what you are looking for is known as the complement. In Excel for Mac you dont need the parenthesis.
Using reverse percentages is a way of working backwards on a percentages problem in order to find the original amount.
C3-C2C2 When you drag the formula down to copy it to other cells the absolute reference C2 will stay the same while the relative reference C3 will change to C4 C5 and so on. 100 - 9 91 is what you need to get back to 100 In probability theory what you are looking for is known as the complement. For example 25 is stored as the value 025 50 is stored as the value 05 etc. To determine the orginal number we simply need to multiply 100 by the inverse of the equal fraction to 25.