|
|
|
|
3 |
101 |
|
|
|
if function by
LCCHELP
I have input the following if function
if(at1av1,at1-av1,0) however if the number in av1 is greater than at1 it
returns a negative number, rather than...
|
|
8 |
74 |
|
|
|
Turning #value into a blank cell by
amik
I have this formula A5/b5-1
Somtimes due to a pivot table there will be no numbers in the A5 and B5.
Curently it gives mea #value. is there a way to...
|
|
3 |
74 |
|
|
|
Problems by
Kay
I have posted this so may times; maybe I am not explaining properly.
Start date March 23, 2006 (Cell K3)
July to June (D8:O8)
I have result D8+D9-10 (In...
|
|
7 |
64 |
|
|
|
Adding problem in excel by
EggMan903
Can anyone tell me why when you enter this into a cell
=-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992
The value comes out 2.32831E-10 when...
|
|
6 |
114 |
|
|
Last 7 days by
bbal20
I am trying to calculate pacing based on the last 7 day average. My dataset
looks as follows:
Date Impressions
5/1/2009 4,562,077
5/2/2009 4,433,984...
|
May 26th, 2009 10:23 PM
by bbal20 
|
9 |
167 |
|
|
|
Unable To Read File - Sumproduct error by
Fluke[_2_]
Hi
I'm using Sumproduct to count rows that meet certain criteria in external
worksheets. If the other sheets are open everything is fine. If not, then I...
|
|
9 |
92 |
|
|
|
Turning N/A cells to blank Cells by
amik
Is there somthing I can insert in to a vlookup formula so that if the cells
comes up N/A that it will be shown as a blank cell.
=VLOOKUP(D21,'Postpaid...
|
May 26th, 2009 07:30 PM
by amik
|
4 |
71 |
|
|
|
Re-post Formula by
Kay
Start date March 23, 2006 (Cell K3)
July to June (D7:O7)
I have result D8+D9-10 (In D11) and I dragged this formula across to O11.
I want a formula that...
|
May 26th, 2009 07:19 PM
by Joel
|
2 |
68 |
|
|
|
Need Countifs Formula Help by
ottodesque
I have created the formula =COUNTIFS('FEB
FY10'!$P$7:$P$126,"Australia",$BG$7:$BG$126,"= 100")/C19. The problem is
that cells BG7:BG126 contain a formula so...
|
|
3 |
86 |
|
|
|
|
May 26th, 2009 07:14 PM
by amik
|
0 |
69 |
|
|
|
Sales Commission Rates by
jcracch
I'm trying to calculate a new sales commission based upon a range possible
values.
Sales Rep earns a different commission based upon Margin % on the sale. ...
|
May 26th, 2009 07:13 PM
by Mike H
|
4 |
94 |
|
|
|
Excluding "0" in standard deviations by
Niclas
Hi,
In calculation standard deviations I am using the formular
=SUBTOTAL(7;B2:B100) which appears to work nicely when filtering. However, it
also includes...
|
May 26th, 2009 05:52 PM
by Niclas
|
4 |
63 |
|
|
|
OFFSET Problems by
John V
Here is a formula which returns an error message:
=OFFSET((ADDRESS(ROW(O2),MATCH(O2,A2:K2,0),,false),1,2)
I am trying to return the value of a cell two...
|
|
3 |
65 |
|
|
|
More than 3 Conditions??? by
gib21
I currently have 3 conditions for a column of cells, as an example;
Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown
Condition 2...
|
|
9 |
58 |
|
|
|
IF OR ??? by
j5b9721
I wrote this is in long form to identify numbers below 11.19 in a daily log &
trigger Conditional Formating daily. But it only works when ALL cells are...
|
|
1 |
103 |
|
|
|
Excel 2007? by
Herbie
Can anyone please tell me where the "Tools" button is?
|
|
3 |
77 |
|
|
|
|
|
2 |
87 |
|
|
|
Count Formula by
Newfie809
Can someone help me with this one, thanks
If I have a Group of Employees Listed by Departments and wanted to know how
many employee in each group have more...
|
|
5 |
134 |
|
|
|
IF OR ??? by
j5b9721
I wrote this is in long form to identify numbers below 11.19 in a daily log &
trigger Conditional Formating daily. But it only works when ALL cells are...
|
|
0 |
73 |
