|
|
Formula in dropdown list by
David Pickering
I am using Data Validation / dropdown to allow a user to select either a
static entry or a calculated one.
There is a line of products a1=apple b1=banana...
|
|
2 |
112 |
|
|
Comments that aren't Comments by
David Pierce
I am trying to put in a worksheet, those things that look
like comments but instantly show up when the cell is
highlighted. Whatever the name of this function...
|
|
2 |
519 |
|
|
If function by
David Platt
I have been on here previously and successfully found an answer to a query
about the IF function. Unfortunately it only works partially and I can't find
my...
|
|
4 |
62 |
|
|
Excel 2007 nested function by
David Price
I can't figure out how to use the Insert Function dialog to create nested
functions in 2007. This is something you could do in earlier versions though
it...
|
|
2 |
73 |
|
|
|
July 27th, 2007 09:36 PM
by David R
|
5 |
59 |
|
|
SUMIF(AND() by
David R. Duggan
I have a sheet with 3 columns
Value Status Type
I want to be able to get total values from these columns based on a
combination of Status and Type.
If...
|
|
1 |
98 |
|
|
|
|
3 |
101 |
|
|
Links and #VALUE by
David Reed
After requesting the updating of links from closed source documents, the cells in the destination workbook are returning #VALUE!. Once the source documents are...
|
December 11th, 2003 11:20 AM
by Paul
|
4 |
104 |
|
|
Drop Down Lists by
David Robinson[_4_]
I need to create a drop down list, that changes selections, based on the
value of a different cell. For instance, if the value in the key cell is
Apples,...
|
April 16th, 2008 04:36 AM
by JP[_5_]
|
2 |
210 |
|
|
nested ifs by
david rose
Hi all,
I am unfamiliar with nested IF statements.
I want to have a formula evaluate the following:
b1=.005, b2 could =-.004 or b2 could =.004
If b1 is ...
|
|
2 |
176 |
|
|
Nesting functions by
David Rose
How many functions can be nested together? Currently, my
function looks like this:
=IF('Dec 11'!I33 ="P",'Dec 11'!$O$1,IF('Dec 18'!
I33="P",'Dec...
|
|
2 |
172 |
|
|
Conditional formatting formula by
David Rose
I want to format the font color in cell G82 by checking the value in cell
D82. The value in cell D82 can be either blank, CAER followed by digits or
COR...
|
March 20th, 2006 11:54 PM
by Pete_UK
|
3 |
100 |
|
|
need to force PT to use formated number by
David Russell
I am generating charts from PivotTable reports. The tables take thier data
from a field that contains a =median() formula. The formula often gives
deicmal...
|
|
2 |
74 |
|
|
Lookup returns unexpected result by
David Ryan[_3_]
Hi Guys its me again sorry. Below is the function and the results obtained. I
have changed the cell format to all sorts with no effect.
Hope someone can...
|
|
4 |
62 |
|
|
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 by
David Ryan[_3_]
Hi Folks the function below works in excel 2007 but not in 2003.
=IFERROR(LOOKUP('HDU Roster'!$C$9,{7,8,11,1330,1430,2245},{8,8,8,8,8,8}),0)
The file is saved...
|
April 15th, 2009 03:25 PM
by Steve
|
4 |
103 |
|
|
lookup formula unexpected results by
David Ryan[_3_]
Hi Folks hope someone can help. One of you guys usually can. So thanks in
advance
The following formula provides unexpected results.
=IF(ISERROR(LOOKUP('Hotel...
|
|
3 |
131 |
|
|
lookup formula unexpected results by
David Ryan[_3_]
Hi Folks hope someone can help. One of you guys usually can. So thanks in
advance
The following formula provides unexpected results.
=IF(ISERROR(LOOKUP('Hotel...
|
|
1 |
133 |
|
|
Trying to lookup values on another sheet by
David Ryan[_3_]
Hi i have a spreadsheet with multiple workbooks.
on one workbook data is entered using lists. (the data for the Lists is on a
workbook called "lists")
when...
|
|
2 |
116 |
|
|
Vlookup formula by
David Ryan[_3_]
Hi i have a spreadsheet that uses this lookup table that lives on a sheet
called "Times".
on the working sheet if CHC is entered then Am is displayed in the...
|
|
2 |
114 |
|
|
|
|
5 |
77 |