How do I do this using an if statement in excel?
If the amount is from 15000-350000 then the tax is .23, if its extactly
350000 then its .15
What I really need to know if theres something similar to "to" in the

Let me start off by saying that I am no where near an excel expert so please
bear with me.
I have a schedule for my employees which is attatched to this post as an html
file.  They are contained in three different sheets within a workbook.  Each

I have detailed data in worksheet "Proposal Status" which are color
coded (ie background color is red, green, yellow, blue).
In worksheet "Summary" I have the following formula in various cells
that pulls data from "Proposal Status" (every 5th row)

I have a spreadsheet generated by .ASP, saved as .xls, has over 1,000
rows and 10 columns are using in-line format to keep leading zeros from
SQL. Values for these colums are in this form, ="001", ="002", ="023".
Try to do filtering using Custom, choosing "is greater than", none of

This is my very first post to this site, and I'm pretty stoked.
So I want to set up a new style to allow me to alternate row shading.
I have been using the following to alternate row shading:
1.Select the range that you want to format

I have eight worksheets in a workbook.  The worksheets contains columns of
numbers with a total at the bottom of each column.  Is there a way I can add
another worksheet that will add all of the totals of the other eight
worksheets?  When the total of any of the eight worksheets ...

If no result is found, how can I have this function return "0" instead of
"#N/A"?
Thanks,
Bill Allen

Let me start off by saying that I am no where near an excel expert so please
bear with me.
I have a schedule for my employees which is attatched to this post as an html
file.  They are contained in three different sheets within a workbook.  Each

I'm using the following VBA code (which I stole from this board, natch)
to dynamically create print headers and footers:
 Private Sub Workbook_BeforePrint(Cancel As Boolean)
       Dim wsSheet As Worksheet

Microsoft Excel 2003 SP2 on Windows XP SP2
The Cut, Copy and Paste icons are greyed out.  They are also greyed out on
the Edit menu.  Obviously the Paste icon is meant to be greyed out until
there's something in the clipboard, however it remains greyed out even when

I am trying to do something kinda complicated.  I have 2 columns.  the first
I would like to do a numbering.  like F1.1,F1.2,F1.3, etc....
But I would only like a number if the second column has the word
"Automated".  The column can also have the word "Manual"  which I want the

I'm looking to use the lookup functions in order to group some figures
together by product code. It's probably best if I detail what I'm trying to
do because the help menu doesn't seem to cater for sum totals.
I have two worksheets within an excel book:

Is there any freeware, shareware out there that will extract data from
say, a bank statement in excel format?

I have a spreadsheet.
Column A has a question.
The next 6 columns have the answer.
The next column has the right answer.

I have a formula that is getting the minimum value of a column but I want to
exclude the zero rows.
I can’t figure out how to exclude the zeros.
Ideas?