Question

To make a number in cell C1 10% smaller than the number in C3 you enter *

=C3*1.10

+C3+110

=C3%10

=C3*.90


​

Answer 1

To make a number in cell C1 10% smaller than the number in C3 the command should be =C3*.90.

• Microsoft Excel allows its users to decrease or increase the value of a given cell by the required percentage.
• To increase the value in cell C3 by x% in C1, the formula to be written in cell C1 is =C3*(1+x%)
• To decrease the value in cell C3 by y% in C1, the formula to be written in cell C1 is =C3*(1-y%)
• Here, to decrease the value, we write =C3*(1-10%)

       Since 1-10%

        =1- 10/100

        =1-0.1

         = 0.9,

        The formula can be written as = C3*0.90.