i am writing a paper for school and i have to calculate the net pay on a
spreadsheet.  the formula my professor wants me to use is gross pay -(
federal tax+state tax)
i used formuia =e3-(f3+g3) and it produces a series of #### in the net pay

How do I  ask this question ?
Here's an attempt.
I have a sheet called ADMIN that contains numerous buttons that run VB
functions I have created.

I was trying to print my excel worksheet. I want the 1st part to be portrait
and the bottom part to be printed as landscape.
Is it possible?
Thanks,

New to this....
I have a list of dollar amounts in column A.  In column B, a 1 or 2 (yes or
no) depending on whether the bid was awarded or not.  I need to create a
running total everytime a 1 is added to column B that equals the total of the

Welcome.
I've created a few pivot tables in my report in Ex2007.
The problem is that there is a group of ppl who have Ex2003 and these pivot
tables looses their functionality (expanding) when opened in this version of

I have an excel file with 4,000 rows and 15 columns.  I need to merge three
columns so I created a new column for the merged data.  Entered formula  
=M1&","&N1&"/"&O1 and that worked as intended for first row.  How do I apply
formula to remaining 3,999 rows?

I have Windows XP english version and office 2007 Dutch version.
When creating a csv file from excel 2007 file a semi colon (;) is used as
list separator instead of a comma (,).
I already tried to change the list separator to a comma via Control

If a formula gives me a negative number, I want to disply it as zero.   Can
you show me how to make that work? In other words, if a formula creates a
value of
"-14", I want it to show up as "0" in the cell.

Searched for: "print"
No results were found matching "print".
Tips for better search results:
Try a different phrase

I have output some data from a large non-Excel database as a CSV file.  I
can import it into Excel just fine but some of the cells include, as well as
text, a few characters that appear as as small square boxes - presumably
special characters of some form.  I wish to replace ...

I want to count the rows in a range 'Tests 1' AF3:AF1000=YES if the date
in the range 'Tests 1' AD3:AD1000 is (<=) less than or equal to the date
in B14 (current sheet) using the following formula:
=IF($B14="","",(SUMPRODUCT(('Tests 1'!$AF$3:$AF$1000=YES)*('Tests

i am wondering how i can set this up so i can page left or right a set number
of columns rather than paging left or right controlled by the data in cells?
For example:  with no data in any cells, and you hit Ctrl + right arrow it
takes you all the way to the end of columns (xfd)??

I am having problems conceptualizing how I can do a specific filtering
of a pivot table. Below is a sample pivot table that has various
colors assigned to each case number. I want to be able to filter this
pivot so that it only shows full records that contain Green.

I have a very simple chart...
The data looks like this:
A           B
Data1    3.65

When I double-click an Excel attachment to an Outlook email, a window pops up
and it cannot find PRO11.MSI, then error 1706, then Excel won't open.  I have
lost the installation CD-ROMs.