=IF(B270,+B27:B32-B28,"") Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is...

The only file, (in Doc Libr), does not have today's date. ? Is there some setting I need to make?

I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 ...

I have the following table sorted by Column A , B A B C 1 apple $1.10 3% 2 apple $1.05 5% 3 apple ...

Hello all, I have audited my formulas over and over and am seeing an odd behaviour in Excel 2007 SP2. I am comparing cost rates. One contract price will be...

I have Windows XP and Office 2007. When I select a range in Excel 2007 and want to have it sort first by the values in Column A and then by the values in...

=SUMIFS(Detail!C:C,Detail!A:A,"=B6",Detail!A:A,"=C6",Detail!B:B,"Installation") Detail Sheet Date Type Qty 2/8/2010 Sales ...

I am trying to concatenate two cells which are in 2 different formats: Cell A1: $5,000,000 Cell B1: 16.90% So, in Cell C1, I am trying to say the following:...

I am trying find a way to format a pivot table so that it will display the row label in each row below it instead of at the top in summary form... This would...

I am looking for a way to put querries in Excel then macro out to web sites and pass or get information.

how can I get my pivot table to show the value in a cell not the count?....(the actual data of the cell)...thanks

Anyone, I have a list of 25 swimming events and a list of 60 swimmers who will each swim in four different events. To make life easier I have created a...

When I try to change the formating on certain cells, one at a time or many, in a multi work book spread sheet I get a warning diolog box that says "Too many...

i want to prepare bell times chart that starts at 9:00am and incresing with 50 min. I want the result to be shown as 9:50,10:40 etc. thanking you in...

In class we learned that there is a feature in excel that speaks Audio actually tells you what is in the cell I would really like to know how to turn this...

Excel 2007 is turning off number lock whenever I start the program. If I turn numlock on, then exit and restart Excel it turns it off. I am unablke to find...

How do you use the sort filter smallest to largest? When I try I see that the numbers are changing not just reordering? Any ideas?

I have a calendar spreadsheet which I created myself which we use to enter for employees days off and partial days off as well as a column to list anyone...

How do you use the sort filter smallest to largest? When I try I see that the numbers are changing not just reordering? Any ideas?

Hi - I have set my regional settings to use brackets (23) for negative numbers. I've set both the number and currency formats to use brackets for negative...