Question about Excel Computers & Internet

Ad

= sumif(E21,"Yes",G21:G23)

Posted on Jul 14, 2017

Ad

You are on the wrong website for this type of inquiry. This is a self help website for the repair and use of manufactured products made for consumer use

Posted on Jun 26, 2017

Ad

Hi,

a 6ya expert 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 repairmen in the US.

the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)

click here to download the app (for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

SOURCE: Excell

if you want to put dates, comments, etc.

you can type wht ever you want in the page.

go to page options then to header and footer

Posted on Jan 28, 2008

SOURCE: Percentages in Excel

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

Posted on Aug 09, 2008

SOURCE: Add 20% uplift price to a pricelist in an excel spreedsheet

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 :)

Posted on Feb 25, 2009

SOURCE: i want the all excel formulas

You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Posted on Jun 19, 2009

SOURCE: budgets in excel

Hi Madih35

My solution is this:

Make sure there is a blank row just above the Total expenses cell.

Rewrite the formula to include the blank cell as well and save.

Every time you have a new expense which requires a new row, insert a row and type in the new cell, instead of typing in the existing blank cell. Your formula will be updated automatically.

Best of luck

Posted on Sep 01, 2009

google-- user manual for excel-- and you will find that information in the 900 pages of the pdf version download

Oct 17, 2017 | Excel Computers & Internet

What do you want to add up to 18? once I understand exactly what your trying to do I will be able to assist you further.

Thanks,

Lee

Thanks,

Lee

Sep 09, 2008 | Microsoft Computers & Internet

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

Use the COUNTIF command. The COUNTIF command can count the criteria for a range of cells. Since you can only use it for one range of cells or criteria, you simply add another criteria to the formula as follows: =COUNTIF(AG1:AG5,"X")+COUNTIF(Sheet2!L1:L6,"X")

Apr 10, 2009 | Microsoft Excel for PC

Yes, Concatenate is the name of the formula.

ex:

=CONCATENATE(.15*B27," to ",.25*B27)

Which would return something like: "15.1254 to 25.5514"

If you want to limit the numbers in the returned data to whole numbers, you need to add the Floor formula.

ex.

=CONCATENATE(FLOOR(.15*B27,1)," to ",FLOOR(.25*B27,1))

That would return something like "15 to 25"

ex:

=CONCATENATE(.15*B27," to ",.25*B27)

Which would return something like: "15.1254 to 25.5514"

If you want to limit the numbers in the returned data to whole numbers, you need to add the Floor formula.

ex.

=CONCATENATE(FLOOR(.15*B27,1)," to ",FLOOR(.25*B27,1))

That would return something like "15 to 25"

Dec 19, 2008 | Microsoft Excel for PC

Yes you can create the formula outside the cell or you can create it one time and copy it down to the other cells. That way it will populate once it is used.

The formula should be Base Rate * .05 to get the result then add the result back to the base rate.

The formula should be Base Rate * .05 to get the result then add the result back to the base rate.

Dec 18, 2008 | Microsoft Excel for PC

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)

2. Click on Add-Ins on the side pane of the Excel Options Window

3. Check to see if Analysis ToolPak is in Inactive application add-in list.

4. If is not, proceed to Step 7

5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"

6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK

7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)

2. Click on Add-Ins on the side pane of the Excel Options Window

3. Check to see if Analysis ToolPak is in Inactive application add-in list.

4. If is not, proceed to Step 7

5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"

6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK

7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

Add an IF statement that encloses the formula you've already written. Assuming the result is in one cell, called CELLREF for purposes of writing this for you:

=If(CELLREF>0,CELLREF,(------INSERT YOUR FORMULA ABOVE------),0)

Thank you for rating FixYa!

=If(CELLREF>0,CELLREF,(------INSERT YOUR FORMULA ABOVE------),0)

Thank you for rating FixYa!

Apr 23, 2008 | Microsoft Excel for PC

Aug 23, 2017 | Excel Computers & Internet

63 people viewed this question

Usually answered in minutes!

=IF(E21="Yes",G21+G22+G23," ")

×