Question about Microsoft Excel for PC

Ad

In cell A1 type amount of cost price, i cell A2 type 37.5, in cell A3 type =A1*A2, in cell A4 type =A1+A3, You will get amount including cost price with 37.5 percent.

Posted on Aug 07, 2008

Ad

Ad

=cost*.375

Posted on Aug 07, 2008

Hi,

a 6ya Technician can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

The concept of "percentage difference" depends upon what you use as your comparator, or the "base" amount.

Suppose the 8.50 value is entered in cell B3 and 4.80 is entered in cell C3.

To compute what percentage you'd save (off the higher price) if you buy from the cheaper supplier, you could enter into cell D3 a formula like: =(B3-C3)/B3

This would result in a numeric value of 0.435294, meaning you'd save about 43.53% off the higher price. In this case, your "base" amount is $8.50.

Alternatively, if you used the lower price as the "base", then you could use a formula like: =B3/C3

This would result in a numeric value of 1.770833, meaning the higher price is 177.08% of the lower price, so it costs about 77% more.

HTH!

Suppose the 8.50 value is entered in cell B3 and 4.80 is entered in cell C3.

To compute what percentage you'd save (off the higher price) if you buy from the cheaper supplier, you could enter into cell D3 a formula like: =(B3-C3)/B3

This would result in a numeric value of 0.435294, meaning you'd save about 43.53% off the higher price. In this case, your "base" amount is $8.50.

Alternatively, if you used the lower price as the "base", then you could use a formula like: =B3/C3

This would result in a numeric value of 1.770833, meaning the higher price is 177.08% of the lower price, so it costs about 77% more.

HTH!

Feb 03, 2014 | Avanquest Spreadsheet Professional Full...

- divide the top of the fraction by the bottom
- Then multiply the result by 100
- add a percent sign to the answer so people know it is a percentage (i.e. per 100)

- e.g. 3/5 *100 = 0.6 * 100 = 60%

follow these steps:

- find a number that you can multiple the bottom of the fraction by to get 100
- multiple both top and bottom of the fraction by that number
- write down just the top number with the % sign added to the end

- e.g. 3/5 as a percentage

- we can multiply 5 x 20 to get 100
- multiple top and bottom by 20 = (3*20)/(5*20) = 60/100 = 60%

I hope this helps and good luck! If you have more questions - ask away! Please take the time to rate this answer.

Don.

Sep 08, 2011 | Computers & Internet

Divide .332 by .233, multiply by 100, then subtract 100.

Alternatively, since the increase in price was .099, divide .099 by .233 then multiply by 100.

Alternatively, since the increase in price was .099, divide .099 by .233 then multiply by 100.

Aug 10, 2011 | Texas Instruments TI-84 Plus Calculator

lets say you have the column B with the prices. Got to column C right beside the first price cell (I'll take B2 as first cell for example) which is C2 and type

=1.2*B2

Copy this formula in the column C all the way down to the last price Cell. That will give you all the updated prices.

Before you delete the column B where all your old prices are you need to do one more thing. Select the entire C column (new prices) go to edit and click on copy. Before you click anywhere else go back to edit and click on paste special and select value. This will change the formula cell you have created a minute ago to a value cell. Now you can delete the old prices. Good luck :)

=1.2*B2

Copy this formula in the column C all the way down to the last price Cell. That will give you all the updated prices.

Before you delete the column B where all your old prices are you need to do one more thing. Select the entire C column (new prices) go to edit and click on copy. Before you click anywhere else go back to edit and click on paste special and select value. This will change the formula cell you have created a minute ago to a value cell. Now you can delete the old prices. Good luck :)

Feb 25, 2009 | Computers & Internet

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:

=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

=(Click cell that you want to work out 30% of)*30/100

Nov 30, 2008 | Microsoft Excel for PC

the formula would be as follows:

X + Y%(X) = Z or 176.37 + .128(176.37)=198.95

If you were going to do this in MS Excelit would be:

assume 176.37 is in A! and the .128 is in A2 and the total will be in A3

A1 + A2(A1) = A3

Remember to multiply by percent, first divide the percent by 100

5% would be .05

Hope this helps

Loringh

X + Y%(X) = Z or 176.37 + .128(176.37)=198.95

If you were going to do this in MS Excelit would be:

assume 176.37 is in A! and the .128 is in A2 and the total will be in A3

A1 + A2(A1) = A3

Remember to multiply by percent, first divide the percent by 100

5% would be .05

Hope this helps

Loringh

Oct 15, 2008 | Computers & Internet

1. enter = symbol

2. enter ( symbol

2. enter cell location where your cost value is

3. enter * symbol

4. enter 0.7

5. enter ) symbol

6. enter 0.175

eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

2. enter ( symbol

2. enter cell location where your cost value is

3. enter * symbol

4. enter 0.7

5. enter ) symbol

6. enter 0.175

eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:

A B C D

1 Question Yes No Total

2 Is sky blue? 20 2 22

3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:

1) click on the cell where you have the division formula

2) clck on Format in the top menu bar

3) click on Cells

4) click on the Number tab (if you're not already there)

5) click on Percentage in the list of categories

6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!

Regards,

RichMTech

If I understood correctly, your spreadsheet looks something like this:

A B C D

1 Question Yes No Total

2 Is sky blue? 20 2 22

3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:

1) click on the cell where you have the division formula

2) clck on Format in the top menu bar

3) click on Cells

4) click on the Number tab (if you're not already there)

5) click on Percentage in the list of categories

6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!

Regards,

RichMTech

Aug 08, 2008 | Microsoft Excel for PC

Lets say Your

MRP = 199

BESTSALE = 130

Now you want to calculate that howmuch percentage of BESTSALE i.e 130, will be added to get MRP i.e. 199.

If m right what do you want, then use the following formula:

Percentage = ((MRP/BESTSALE) - 1) x 100

In your case 199/130 = 1.5307....

So 1.5307 - 1 = 0.5307

Then 0.5307 x 100 = 53.07 %

Thanks

Iqbal

MRP = 199

BESTSALE = 130

Now you want to calculate that howmuch percentage of BESTSALE i.e 130, will be added to get MRP i.e. 199.

If m right what do you want, then use the following formula:

Percentage = ((MRP/BESTSALE) - 1) x 100

In your case 199/130 = 1.5307....

So 1.5307 - 1 = 0.5307

Then 0.5307 x 100 = 53.07 %

Thanks

Iqbal

Mar 10, 2008 | Office Equipment & Supplies

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

240 people viewed this question

Usually answered in minutes!

×