First

Prev 
Next

Last
Pages: 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169
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) 9687273. 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 