|
|
|
Ignore NA in a formula when I type it in a cell
Tue, 26 Aug 2008 13:38:00 -0700
=IF(F6>0,10,0)+IF(H6>=1,10,0)+IF(I6>=1,10,0)+IF(Q6>=0,10,0)+(K6*20)+(M6*20)+(O6*20)-SUM(R6+S6)
When I put a NA into cells K6, M6, O6, R6, S6, it won't calculate obviously
because NA is not a number. It gives me the error message. Is there some
way to bypass this when a cell has a NA?
--
Thanks!
Ty ...
|
Ignore blanks in multiplication formula
Tue, 26 Aug 2008 13:38:00 -0700
I've got a column of ten cells that I want multiplied together, i.e.,
=A1*A2*...*A9*A10. A couple of these cells are blank, and I want to ignore
those cells. For instance, say cells A3, A4, and A7 are blank, then I want
the product to come out =A1*A2*A5*A6*A8*A9*A10 rather than just zero. In the
next colu ...
|
Count range of data
Tue, 26 Aug 2008 13:22:01 -0700
I am trying to use the > with a date and a range of cells with a count range.
=IF(f7:f11>7/31/08,COUNT(b7:b11),"") I am getting a value error. What I am
wanting my end result to show is if the dates within f7 to f11 are < 7/31/08
count how many invoices I have with an August date that are in the range of
B ...
|
Using less than "<" in formula
Tue, 26 Aug 2008 13:09:01 -0700
I'm trying to use a formula in one worksheet that draws data from two other
worksheet. I have no problem using the ">" in formulas, but when I use the
"<" it won't work. My formula is =if(ust!i9="m9",
if(rawdata!r2"<05may08",ust!$b12," ")
It has issues with the date. I tried using AND in the formula bu ...
|
RE: Using less than "<" in formula
Tue, 26 Aug 2008 12:53:13 -0700
=if(ust!i9="m9",
if(rawdata!r2<datevalue("05 may 08"),ust!$b12," ")
"Bernie R" wrote:
> I'm trying to use a formula in one worksheet that draws data from two other
> worksheet. I have no problem using the ">" in formulas, but when I use the
> "<" it won't work. My formula is =if(ust!i9="m9",
> if( ...
|
Stock quotes in Excel
Tue, 26 Aug 2008 12:46:01 -0700
Until today I was able to get & update stock quotes in my excel spreadsheets
using
=msnstockquote(a1) etc.
When I click on the "add-ins" "update quotes" today the cells where the
price should go changes to "#NAME?".
please help! ...
|
SUMIF & MEDIAN with blanks & text
Tue, 26 Aug 2008 12:43:01 -0700
I had some help putting together this formula, but it has been giving me some
grief for some reason after it seemed to work ok to start with.....
=IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,FALSE)),$C3,Qualified),MEDIAN(IF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,FALSE))=$C3,Qualified) ...
|
|
|
Need to rename table columns in excel from a query
Tue, 26 Aug 2008 12:31:06 -0700
...
|
returning a text value using a formula
Tue, 26 Aug 2008 12:26:02 -0700
There is probably an easy solution to this, but I canâ??t find it. Any help
would be appreciated. I have 3 columns. Each column has a heading with
numbers in each one, and a total at the end of each one (totaling all of the
column numbers together). Iâ??ve set up a formula(MAX) that returns the
highest n ...
|
Import External Data by Date
Tue, 26 Aug 2008 12:05:00 -0700
I have a query setup in an Excel spreadsheet that imports external data from
SQL. All of the data is imported but, I only want the data for the current
date imported daily. Can this be done? ...
|
|
|
