How can I combine formula of Average with IF

Ad

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

Posted on Oct 25, 2007

Ad

Thanks judesoul.......u got it...

Posted on Oct 29, 2007

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.

Good luck!

Posted on Jan 02, 2017

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

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

A 99 sonoma 2wd 2.2L 4cyl with the 4 speed auto will get 22mpg on average, 19mpg in the city and 26mpg on highway

4.3 6cyl 4wd with 4 speed auto will get 18 combined average, city 16 and highway 21.

4.3 2wd auto will get 18 combined average, city 17 and highway 22.

4.3 5 speed manual 2wd will get 19 combined, 17 city and 23 highway.

4.3 4wd 5 speed manual will get 18 combined, 17 city and 21 highway.

These estimates from an online source, my buddy has the 4.3 4 speed auto 4x4 and he averages about 16 on average.

hope this helps.

4.3 6cyl 4wd with 4 speed auto will get 18 combined average, city 16 and highway 21.

4.3 2wd auto will get 18 combined average, city 17 and highway 22.

4.3 5 speed manual 2wd will get 19 combined, 17 city and 23 highway.

4.3 4wd 5 speed manual will get 18 combined, 17 city and 21 highway.

These estimates from an online source, my buddy has the 4.3 4 speed auto 4x4 and he averages about 16 on average.

hope this helps.

Jul 25, 2011 | 1999 GMC Sonoma

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

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

726 people viewed this question

Usually answered in minutes!

recently it has become necessary in my job to determine how many likely number combinations would equal a given total. No one here knows how to make that determination. We have both ms access and excel, but still do not know how to use either of them to our advantage in this situation. please help

×