I would like to set up a conditional formula but am not sure how to do it. If
A1-B1 > 0, then put the answer in cell D10, but if A1-B1 is = 0 or < 0 then
put the answer in cell D12.
Any help would be appreciated.

I'm getting an error "formula too long" for the folloiwng IF statement:
=IF(B15="",0,IF(B19="Full Splash”, INDEX(‘Sheet 1’!$A$1:$L$3, MATCH
($B$5,’Sheet 1’!$A$1:$A$3,), MATCH($A$13,’Sheet
1’!$C$1:$L$1,))*VLOOKUP(B15,’Data Table’!$U$10:$V$15,2,FALSE), (INDEX(‘Sheet

I've a workbook with several worksheets, namely "Jan06", "Feb06"......and
"Summary". This Summary worksheet consolidates all data from columns A, B & E
of all other worksheets in the same workbook(they are identical). Every time
when I filled in all records for that month, I've ...

I have a list that show mulitple times in my spreedsheet and I need t
know how many actual numbers are there Ex: I actually have 5 order
here.
398805

Is there a way I could invert a series on a graph?  Lets say my data points
are 3,9,2,4,7, but I really want graphed 7,4,2,9,3. Is there a way I could
just switch this in chart options? Here's the complicated part, a simple
solution would be to just invert the numbers in the ...

Hi there, I have a sheet that I am using to keep tabs on follow up interviews
in a research project. When the participant is interviewed I have either the
date it occurred or "client withdrawn" or some comment like this, or the cell
is blank.

Dear experts,
I want to create a pivot table by using Multiple Consolidation Ranges.
According to general creating procedure, a pivot table comes out with the
first column of the source data tables as "Row" and the other columns as

In Excel 2003, I want to calculate the number of years and months employed
using a hire date and the current date. i.e.
06/28/2006 – 06/25/2005 = 11 months
06/28/2006 – 06/25/2004 = 1 year 11 months

When I am about to filter some of my data i have, i.e finding all the data
with a certain date, the information appears incomplete and a blue spider or
bug appears

I am trying to use a literal cell reference as a part of the criteria in the
SUMIF function, and i can't get it to sum properly.  It only seems to like an
actual value, not a cell reference, to work properly.  Does anyone know a
roundabout for this?  

How can I parse address data in Excel to meet USPS requirements for
addresses? I work on spreadsheets with sometimes 1,000s of addresses and want
to write something that will correct (as best as possible) the data so it
meets Postal Service regs for address correctness. I figure ...

How can you prevent getting a N/A error message when using a lookup formula
if the reference cell is blank?

I created a workbook that has individual sheets with 5  separate contestant
scores.  The last sheet is a total page with point totals for each contestant
as a reference from their individual sheet in column 1 and the corresponding
contestant name in column 2.  I am trying to use ...

end result
formula that will provide monthly dollars sold for a sales rep for a certain
product
excel worksheet has columns for month, actual date, $sold, rep name, product

With assistance from one of the learned members, I used the following formula
to add together the sum of each pair of adjacent columns (this calculates
total daily interest for all accounts, where the balance and interest are
unique per account)