Excel
How do I find the sum in an Excel spreadsheet?

Answer Question   |  May 6, 2013  11:55 PM
Microsoft Excel, Microsoft Excel formulas

Cell formula
I have a simple 2 column balance spreadsheet. I have my starting balance in column E Cell E4. I want to have a running balance in Column E. Column D has deduction amounts from balance in Column E. I have entered formula =(E4-D5) in cell E5 but this automatically enters the same starting balance from [...]

Answer Question   |  April 1, 2013  3:52 PM
Microsoft Excel 2007, Microsoft Excel formulas

Number formats
I pasted a bank statement into Excel but I can’t successfully do any calculations. Can you help?

Answer Question   |  March 4, 2013  3:30 PM
Microsoft Excel, Microsoft Excel formulas

Excel formula program
Hi, I’m trying to do a table where I need to calculate how much commission I’m paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but… I don’t want the whole column to change to 10% because I [...]

Answer Question   |  February 25, 2013  1:59 AM
Microsoft Excel 2007, Microsoft Excel formulas

Excel conditional formula
Hi all, I can write a basic conditional formula such as =IF(A1=”23″, “OK”, “NOT OK”), but I want to add a supplementary condition … For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate… both conditions need to be met. TIA, John

Answer Question   |  February 1, 2013  8:46 AM
Microsoft Excel, Microsoft Excel formulas

Calculate overtime in Excel
Hi All, I need to work out if the time captured in my AmendedDate column falls outside normal business hours. So basically I am reporting for a Call Centre, which logs support tickets. In my Database I already have a created Date (when the Ticket was Issued), AmendedDate (When the technician made any changes) and [...]

Answer Question   |  January 22, 2013  9:20 AM
Microsoft Excel 2010, Microsoft Excel formulas

Find and replace formula in Excel
Hi everybody. I am forex and options trader. Options contracts look like this: ‘GOOG 121005C770″ or “GOOG 121005P770″. I need to have a formula that can lookup the cell and if contains “*******P***” to replace the whole cell with “Put” and if the cell contains “*******C***” to replace the whole cell with “Call”. Now I [...]

Answer Question   |  October 8, 2012  11:48 AM
Microsoft Excel 2010, Microsoft Excel formulas

Function with hours & minutes involved
Any ideas on how to do the following: I have a payroll spreadsheet that has columns that show the clock in and clock out time that I formatted the cell to give me miliatary time.  I then have a “sum” column that subtracts one from the other to give me thetotal hours/minutes worked.  I have two of [...]

Answer Question   |  May 7, 2010  2:38 AM
microsoft excel 2007 formulas, Microsoft Excel formulas, microsoft excel functions, Microsoft Windows Vista

Creating a list in one Excel cell by referencing several other cells
Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would [...]

Answer Question   |  June 9, 2009  2:46 AM
Concatenate, Microsoft Excel, Microsoft Excel formulas

Paste values over a formula on condition of a column in same sheet
Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 [...]

Answer Question   |  April 21, 2009  9:49 AM
Excel VBA, Microsoft Excel formulas, Microsoft Excel macros, VBA, Visual Basic for Applications

Excel Macro to extract substrings from a comma-separated string.
How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

Answer Question   |  April 13, 2009  6:17 AM
Microsoft Excel, Microsoft Excel formulas, Microsoft Excel macros, String manipulation

Microsoft Excel subtraction using VBA
I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in sheet1.By [...]

Answer Question   |  April 13, 2009  11:26 AM
Microsoft Excel, Microsoft Excel formulas, VBA, Visual Basic for Applications

How can I find an Excel formula that helps me change text?
How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form [...]

Answer Question   |  March 4, 2009  12:30 AM
Find and Replace, Microsoft Excel, Microsoft Excel formulas, Microsoft Word, Search and Replace

Multiple VLOOKUP with multiple results
There is 3 sheets 1st master sheet,2nd B-1 & 3rd B-2.In (master sheet) column A there are repeating towers name (eg:B-1,B-2,B-1,B-3), column B there are repeatation of apt. no. (eg: 101,102,101,103,104,102), column C there is a amount(eg: 15000,20000,etc.), i want to give formula in each sheet to get data from the master sheet in ascending [...]

Answer Question   |  October 21, 2008  5:40 AM
Excel formulas, Excel VLOOKUP function, Microsoft Excel, Microsoft Excel formulas, VLOOKUP, VLOOKUP function