Question about Business & Productivity Software

1 Answer

Excel Formula I have such a head cold I can't think with this headache. Please resolve I have a spreadsheet that I want in column M Row 2, I would like the formula to look at Column I, Row 2, minus Column F, Row 2 and return a zero so far this is the formula I have =IF(I2-F2,0) But I also want it to look at I2-F2 when a number is added to I2 so I can get a net amt. I hope this is enough of an explantion. Ishould really know this but the brain is in brup mode. Thank you

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 26 Answers
Re: Excel Formula

Do you simply need to have the formula: = I2 - F2

Is there a condition that you want to return zero?

Posted on Jan 21, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Excel Spreadsheet question

cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Apr 09, 2014 | Microsoft Excel for PC

1 Answer

Cell freeze 3 rows together at a time.

Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.

Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.
Freeze or lock rows and columns
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
Open the Excel spreadsheet.
Navigate to the "View" tab on the top menu.

3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.


Select the "Freeze Top Row" option to freeze the top row.


Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.


Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.


Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.


Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns

Open the Excel spreadsheet.


Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.


Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.


Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.


Navigate to the "View" tab on the top menu.


Click on "View," then click on "Freeze Panes." A drop-down menu opens.


Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.


Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.


Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."
Freeze or lock rows and columns
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Business & Productivity...

2 Answers

I need a running balance in a column for a petty cash spreadsheet

In the first row of numbers, assume row 3 for example (leaving 2 rows for titles, put in cell E3: =C3+D3. In the next row (assuming row 4, put in cell E4: =C4+D4+E3. Use fill down to populate this formula all the way down.

Jun 18, 2009 | Microsoft Excel for PC

5 Answers


No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.

Nov 26, 2008 | Microsoft Excel for PC

1 Answer

Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Business & Productivity Software

3 Answers


The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

2 Answers

Display calculation result in a previous cell

Look into the =SUMIF function, it sounds like this may be what you are looking for.

Hope this helps!

Apr 09, 2008 | Microsoft Excel for PC

1 Answer

Average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??

hi this my id plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

2 Answers

Duplicacy in excel sheet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

84 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides