You could do it in a few ways. Assumung the cost price was in cell A2 and in another cell you wanted to show it having been increased by 20%, you could do any of these:
=A2*120%
=A2*1.2
=A2+A2*20%
=4+9
"=((B1-A1)/B1)*100" alternatively if you format the cell as a %, it would just be "=(b1-a1)/b1"
=G31*1.5+3 or =(G31*1.5)+3
To reference an Excel sheet in a formula or function, you can use the sheet name followed by an exclamation mark (!) before the cell reference. For example, to reference cell A1 in a sheet named "Sheet1", you would write "Sheet1!A1" in the formula.
A nested formula is where one or more functions are placed inside another function to make a formula. For example you can write a formula where you put an IF function within an IF function and this would be a nested formula.
Use the decimal form of 12 percent which is 0.12 and format it to percentage, or type in 12% and it should align to the right as a percentage.
=205-200/205*100
50,000,000 * (5/100)/100 = 50,000,000*5/10,000
You question is not very clear. However, based on what you have asked I understood that you need to know how to write formula in MS Excel. To write formula you need to start with = Like if you want to add values from cell A1 and A2 and want results in A3 then A3 will have =A1+A2 or A3 will have =SUM(A1:A2)
Yes. One of the reasons that you can name ranges is to make formulas easier to write and understand.
Many formulas are mathematical, so if you can't do maths on paper, then you won't be able to do it in Excel.
=d4%10