Functions

How do I tell Excel to insert data from a cell 4 to the left?
Hi there, Here's the situation. I have a bunch of game prices in cells I8:I15. In cells B8:B15 are the names of these games. I have a cell that gives me the highest price [=MAX(I8:I15)] but instead of showing the price, I want it to show the name of the game. But I don't want to have to enter the name myself, ... 6 Mar 2010 01:04

What does " mean in excel
When working in excel and doing my labs, I am often told to use " " in my formulas but I don't know what " " stand for and the ! is also used, can someone explain to me what " " and ! mean? ... 7 Mar 2010 08:31

In a formula, how do I set a maximum acceptable value?
I need to calculate my loss on a rental property but the loss cannot be greater than $25,000 no matter how large it actually is. How do I write an Excel formula that will include this maximum value limit? ... 5 Mar 2010 21:50

COUNTIF
Column E2:E61 contains only numbers between -1 and 3. In E62, I want a formula that will tell me the number of times both 0 and 2 appear in the column. Example Column E Row 2 0 Row 3 -1 Row 4 3 Row 5 -1 Row 6 2 Row 7 0 Row 8 ... 5 Mar 2010 21:50

Pulling out invoices that do not match
Hi, I have 2 columns , Col A has invoice numbers and Col B has invoice numbers. All of the invoices will be included in Col A but all will not be included in Col B. I want to be able to pull out the invoices in Col A that did not have a corresponding Invoice number in Col B. Col A Col B 123456 ... 5 Mar 2010 23:59

I there a way to not print a cell(s)?
I would also like to know, is there no way of just not printing a few cells, I think that I have tried everything, but setting print areas do not work. Is there really no way so information is accessible on the computer screen but not when printed? "Khamul" wrote: Set a print area th... 5 Mar 2010 19:38

How to format the phone number
Hi, Can any one tell me how to get rid off the "-" at end of the data (downloaded from SAP). The data I download from SAP look like this (203) 968-7273-. I would like to get rid off the "-" at the end to make my work sheet looks better. I have over a thousand rows, so it is almost impossible to do it manu... 5 Mar 2010 19:38

Multiple rate of pays
On a spreadsheet, the date worked would be in column A; employees' name are in column B. An individual maybe listed several times in column B . In column C would be # of hours worked that day. What formula could be used so I don't have to type the rate of pay (which should stay hidden) for each person every ... 8 Mar 2010 16:26

if formula results in False - can you help?
Here is my formula - it ends up with FALSE - I must have a ) in the wrong place can anyone help? Essentially I don't want to end up with a ##### (negative number result) so I came up with this formula. If there is a way to make the ##### actually look like a proper negative number or blank that would be ev... 5 Mar 2010 19:38

multiple calculations in 1 cell
In cell C 13 is the quantity of units. In cell G 13 is the total cost. In cell G 6 is the percent of overhead and in cell G 8 is the percent of profit. I want to enter a formula in cell H 13 that will give me a unit price which is (cost plus overhead) + profit. ... 5 Mar 2010 18:30