Here's what I have:
A1 = .75  (that's point seventy-five, less than zero)
B1 = the argument =IF(A1<0,A1,0)
The result I get in B1 is 0 when it should get the number in A! which

How do I get the fonts in a spreadsheet to change colour two months before
the date inserted.
Thanks in adavnce
Jason

I have the following code that takes an age to process when i have
alot of items (5000 takes approx 1 hour.). Is there a more efficent
way i can process this? I am using Excel 2007 and writing in
formulars

Does anyone know if it is possible to remove an autoformat from a pivot table
once the document is saved? I would like to return the pivot table to its
original form before the autoformat. Thanks.

Can  any body think of a formula if i want to sum up each collection as
follow, because i have a lot of collection cell i have to calculate.
A              5000
B              2000

I was trying to use sumproduct to calculate if column a was a date and
column b was item and column c was a dollar amount so I would know how many
items sold during a specific month and year. It works to calculate the exact
date (7/2/2007 or 7/4/06) but I want it to calculate by ...

I am using MS Excel 2007. I have a workbook with many worksheets. Sometimes I
need to see the headings, sometimes not. Is it possible to turn on or off the
headings for ALL the worksheets simultaneously. Thanks.

Je n'arrive pas à utliser la fonction "envoyer vers" dans
- Microsoft office picture manager
- Microsoft office word 2007
- Micosoft office excel 2007

Can I get words to switch places without having to do it by hand? I have a
worksheet with 2300 names and addresses in rows. However, I need the name  
column to read Last Name first. It doesn't. For clarification....It reads
John Doe & I need it to read Doe John. I inherited this ...

I am using MS Excel 2007. A month or so ago I asked for help to reduce the
size of blank rows (currently 16 points) down to 8 points. The Excel experts
advised me to try this macro:
Sub Reduce_Height_of_Empty_Rows()

I have read the "help" section several times but am still not able to find
out how I can freeze several opening lines at the top of a document as a
header. I am sorry if I am slow at understanding but the method is not
obvious to me. Can someone help me out here?.

I am learning Excel myself. Right now I'm in a problem doing something
I have a workbook with three columns. Column 1 contains Email addresses
Column 2 contains First Name and Column 3 contains Last Name.
My second workbook contains only email addresses (a few) from firs

A new user reported this. I thought they must be doing something wrong,
but now I see it on my own system.
Vista SP1
Office 2007 SP1 (all defaults)

I frequently encounter situations where I want to perform a set of
similar calculations on different data. If it's a table, like new a
series of readings over time, I can set up a row for each entry and
copy the formulas down each time I add a new row.

At the moment my spreadsheet has figures in such as 303 and 528. These
numbers represent thousands. So 303 means £303,000 and 528 means £528,000.
How can I quickly change the basic figures to represent the currencies as
above? Thanks.