Question about Microsoft Excel for PC

# Excel-combine average formula with if

How can  I combine formula of Average with IF

Posted by on

• Anonymous Mar 25, 2014

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

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

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

Posted on Oct 25, 2007

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

Posted on Oct 29, 2007

## 1 Suggested Answer

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

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### I need to know how many gallons of water are in my pool

Formula For Average Gallons In Rectangle, Square Or Freeform Pools:
Length x Width x Average Depth x 7.5 = Total gallons
Formula For Average Gallons In Circular Pools:
Diameter x Diameter x Average Depth x 5.9 = Total gallons
Formula For Average Gallons In Oval Pools:
Length x Width x Average Depth x 5.9 = Total gallons
Formula For Average Depth Of Pools With Slopes:
Shallow End Depth + Deep End Depth Divided by 2 = Average Depth

Jun 18, 2017 | Pool & Spa

### How to calculate an average on a cell by cell basis ?

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.

Jul 22, 2014 | Microsoft Excel Computers & Internet

### Average Handling Time for Emails

You only need one formula for this.
Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

### What are the formulas in grading the grades uisng microsoft excel

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.

1. All formulas begin with an equals sign (=).
2. 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.
3. 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.
4. 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.
5. 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

### Whats my average mpg?

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.

Jul 25, 2011 | 1999 GMC Sonoma

### NEED TO AVERAGE CELLS, WHERE ONE OR MORE CELLS CONTAIN ''0'' OR ''#D

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

Aug 26, 2009 | Microsoft Office Excel 2007

### Working hours calculation (with Neg time) in Excel

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.

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

### Excel will not displaying the results of a trend array formula

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.

Sep 30, 2008 | Microsoft Excel for PC

### Exel 2003

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
1. Click the cell in which you want to enter the formula.
2. 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).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

### Excel and the AVERAGE function

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.

Dec 30, 2007 | Computers & Internet

#### Related Topics:

726 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert