Summary: I am pretty new to IF statements in the context of excel and have no idea how to complete the latest one I need. Basically Its like this: The are thre...
Summary: Hi, I presume that this is some sort of assignment. As such I won't provide a solution, but I can point out several issues with the formula you poste...
Summary: Hi, You haven't said what values are in column B, but as you are using COUNT() which counts the number of cells containing a number (Excel help states...
Summary: Hi, You have added a 'value_if_false' to the final IF and now you get zero instead of FALSE. This tells you that the criteria you have in each of your...
Summary: Hi, Use VLOOKUP instead of LOOKUP. (According to the help files LOOKUP is present only for backward compatibility). VLOOKUP takes an additional argume...
Summary: Excel Data Validation: The following Formula will determine if the data entered into a cell (D3) is a Capital "Y". If so it will allow it, otherwise r...
Summary: I have an extremely simple Excel spreadsheet that I use to keep track of my running. It's columns are: Date, time to run a mile, time to run 2 miles, ...
Summary: First, may I suggest that you use a subject line more relevant to the contents of your post? If everyone used a subject line like "Help" or "Need Exce...
Summary: how can i increase a cell reference by one row automatically. The summary worksheet references individual worksheets. I need the summary worksheet to...
Summary: Hi, I have a couple of questions: 1. What steps are you doing to merge the Excel data into Word. If I have 4159.68000000003 in a cell in Excel, but ...
Summary: Hi, 1. When you say the form is sent out (e-mailed), what does the form consist of? Is it just an Excel workbook with a sheet in a particular format (...
Summary: Hi, From your post, I thought that you were familiar with conditional formating formulas, which is why I didn't provide any instructions for using it,...
Summary: Hi, You didn't mention searching for a cell with an error value before! Excel has a function that returns TRUE if the cell contains an error: If cell ...
Summary: Yes - I agree. If I had Dbase II Plus on here, I could do it in 2 minutes flat. The reality is that... 1 - Not many people will (or can) spend a larg...
Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i...
Summary: Even though you didn't ask a question, I should inform you that this forum is for MS Office realted products, such as Word, Excel & Outlook. If you ha...
Summary: I have a client that needs a formula to calculate the total cost of meals on monday thru friday... easy enuff =(a2+b2+c2+d2+e2) however, on certain da...
Summary: Hi Guys - Is it possible to utilise the indirect function or a means using VBA to populate the listfill range of a combobox - this is also referred to...
Summary: In this forum, we don't usually answer homework questions directly, since the object is for you to figure how to use Excel to complete the assignment....
Summary: Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows,...
Summary: Hey All I hear you guys are pretty good. I need help with an excell chart being imported into a word document. I inserted it as an object and ticked t...
Summary: Hi, If this sorting by date is not done very often then I suggest using Excel's Sort function manually. For sort to work, all the data for each indivi...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
