excel formula?

So J12 has a number (say 100), and you want J13 to be 30% less than that (e.g. 70).

Any of the formulas below will do that for you if you type them in J13:

=J12 * .7

=J12 * 70%

=J12 * (1 - .3)

=J12 * (1 - 30%)

=J12 - J12 * 30%

If you need more info, add more details or e-mail.

Cheers.

.

Are the numbers to the right of the / character always one digit in length? If so, paste this formula in D16 =SUMPRODUCT((N(RIGHT(A1:A1000, 1)=RIGHT(D15,1)))*(B1:B1000)) If your data goes past row 1000, change the 1000's to some number larger than what you have. The above formula assumes all your data in column A starts with g/z.

Clic into the cell you want the answer to appear and write

=0.70* and then clic into the cell where is the number you want to calculate the 30%

Then press ENTER and thats it!

X=N-(N*.30)

Where X is your answer, N is the number

Click on the formula as you set the answer to be at B1 referenced to A1. B1 formula will be =$A1*0.7.

=cellreference*.7

=(cell number)-(.30)

=SUM(A1-(A1*30%))

or

=SUM(A1*70%)