answersLogoWhite

0

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%

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How do you write a formula for 4 plus 9 in excel?

=4+9


How do you write an excel formula to find the gross margin percent if A1 is cost and B1 is retail?

"=((B1-A1)/B1)*100" alternatively if you format the cell as a %, it would just be "=(b1-a1)/b1"


How do you write this formula in excel G31.5 plus 3?

=G31*1.5+3 or =(G31*1.5)+3


How to reference an Excel sheet in a formula or function?

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.


What is the nested formula of MS Excel?

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.


How do you write 12 percent in a Excel sheet?

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.


How do you write 205 minus 200 divided by 205 multiply by 100 in excel formula?

=205-200/205*100


How do you write formula 5 percent percent of 50 million?

50,000,000 * (5/100)/100 = 50,000,000*5/10,000


Formula to calculate in Excel?

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)


Can named ranges be used in an Excel formula?

Yes. One of the reasons that you can name ranges is to make formulas easier to write and understand.


Why do you need first have to understand how to calculate math using the paper and pencil method before you can write a formula in Excel?

Many formulas are mathematical, so if you can't do maths on paper, then you won't be able to do it in Excel.


How you write in Microsoft Excel to make a number in cell A1 10 percent smaller than the number in D4 you enter?

=d4%10