Question about Microsoft Computers & Internet

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

Length x Width x Average Depth x 7.5 = Total gallons

Diameter x Diameter x Average Depth x 5.9 = Total gallons

Length x Width x Average Depth x 5.9 = Total gallons

Shallow End Depth + Deep End Depth Divided by 2 = Average Depth

Jun 18, 2017 | Pool & Spa

In cell B1 put the formula =AVERAGE(A$1:A1)

Copy the formula then paste it into cells B2 through B5000

You can use any other column, of course.

Copy the formula then paste it into cells B2 through B5000

You can use any other column, of course.

Jul 22, 2014 | Microsoft Excel Computers & Internet

You only need one formula for this.

Total handling time divided by the total number of emails answered.

Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

Use this formula for the average of C1 + C2

=AVERAGE(C1,C2)

=AVERAGE(C1,C2)

Jul 08, 2011 | Computers & Internet

Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

Hi Aviks,

Normal average works well for linear distribution, but here is non-linear distribution of work. So here is the formula that has been taken from project management concepts. Please try for different values of x and y

Try to keep x+y=6

=(StandardWorkingHr*x+(ActualWorkingHr-StandardWorkingHr)*y)/(x+y)

e.g.

=(StandardWorkingHr*5+(ActualWorkingHr-StandardWorkingHr)*1)/5)

if you can share data with me, I can give you the exact formula.

Normal average works well for linear distribution, but here is non-linear distribution of work. So here is the formula that has been taken from project management concepts. Please try for different values of x and y

Try to keep x+y=6

=(StandardWorkingHr*x+(ActualWorkingHr-StandardWorkingHr)*y)/(x+y)

e.g.

=(StandardWorkingHr*5+(ActualWorkingHr-StandardWorkingHr)*1)/5)

if you can share data with me, I can give you the exact formula.

Mar 09, 2009 | Microsoft Office Professional 2007 Full...

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (**!**)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

- Click the cell in which you want to enter the formula.
- In the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or
formula stored in the active cell.)
, type
**=**(equal sign). - Click the tab for the worksheet to be referenced.
- Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Computers & Internet

try this site...i hope thats what you mean when you say combine both formula.

Oct 25, 2007 | Microsoft Excel for PC

Jul 25, 2018 | Microsoft Computers & Internet

14 people viewed this question

Usually answered in minutes!

×