Question about Microsoft Excel for PC

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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 repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

To

https://www.youtube.com/watch?v=byTDwUQAwnE May 28, 2014 - Uploaded by Helpfolder

there this is another tutorial on

https://www.youtube.com/watch?v=p-Frr5coC_4 Feb 16, 2014 - Uploaded by Google Sheets

This Tutorial Shows the

formula to add and subtract in google sheets Google Search

Mar 13, 2018 | Google Computers & Internet

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...

not really

Just create the

formula =if(e1=1,"X",if(e1=2,"Z","")) in cell K1 then

formula =if(f1=1,"X",if(f1=2,"Z"),"") in cell L1 then

formula =if(g1=1,"X",if(g1=2,"Z","")) in cell m1 then

formula =if(H1=1,"X",if(h1=2,"Z","")) in cell N1 then

if you wanted another statement

formula =if(H1=1,"X",if(h1=2,"Z",if(h1=3,"Y,""))) in cell N1

this is nesting the if statement you just keep adding conditions.

What you are asking I have to type this in 600 times

No just do one line and then highlight the cells with the if in it and then select copy from edit menu or right click and select copy

Then click on next 599 cells by clicking on first cell and hold mouse button down and drag down mouse to last 1000 row of cell and right click mouse and select paste. The formulas will alter accordingly as pasted to each cell

You could also use a vlookup statement

you open another workbook look at bottom of worksheet for tabs to add a workbook.

Then you create a table in other workbook

1 cell A1 H in B1

2 cell A2 Z in B2

https://www.timeatlas.com/vlookup-tutorial/

you would still need to copy the cells down

Just create the

formula =if(e1=1,"X",if(e1=2,"Z","")) in cell K1 then

formula =if(f1=1,"X",if(f1=2,"Z"),"") in cell L1 then

formula =if(g1=1,"X",if(g1=2,"Z","")) in cell m1 then

formula =if(H1=1,"X",if(h1=2,"Z","")) in cell N1 then

if you wanted another statement

formula =if(H1=1,"X",if(h1=2,"Z",if(h1=3,"Y,""))) in cell N1

this is nesting the if statement you just keep adding conditions.

What you are asking I have to type this in 600 times

No just do one line and then highlight the cells with the if in it and then select copy from edit menu or right click and select copy

Then click on next 599 cells by clicking on first cell and hold mouse button down and drag down mouse to last 1000 row of cell and right click mouse and select paste. The formulas will alter accordingly as pasted to each cell

You could also use a vlookup statement

you open another workbook look at bottom of worksheet for tabs to add a workbook.

Then you create a table in other workbook

1 cell A1 H in B1

2 cell A2 Z in B2

https://www.timeatlas.com/vlookup-tutorial/

you would still need to copy the cells down

Mar 30, 2017 | Microsoft Office 2003 Basic Edition...

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

Try having the cells refer to the ones you would like in the formula then have a statement something like if a = 1 then yes or if a = 2 then no and have it after become a percentage by dividing the sum by the count. Let me know if you need more help.

Dec 17, 2008 | Computers & Internet

=10000*(1+0.96)^12

=10000*(1+0.10)^18

=10000*(1+0.10)^24

=10000*(1+0.10)^18

=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

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

go to page setup and under scaling you can adjust to your required percentage

Jul 22, 2008 | Microsoft Excel for PC

hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

157 people viewed this question

Usually answered in minutes!

×