I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by...

I want to express a number in to text format 2235 to "Two thousand two hundred thirtyfive"

Hi Can someone please tell me how to create the parentheses { } around a formula? Instead of using just the ENTER key, I think you have to use something...

Need to calculate total hours of two different date & time & difference between day & time. e.g A1= 8/15/2008 22:30 B1=8/20/2008 22:33 ...

I have a spreadsheet with multiple column data sorted by date. I am looking to create a report that will count the number of text occurances on a given...

In Excel to sort an area on several columns, I have to select the columns every time I want to resort the area. Can I store the sort argument for the sheet...

I have two columns that I want to merge into one. The first column is as month day column 21-Aug and the second column is a year column, ie 2003. Is there a...

Hi, I want to assign a group to each of my data columns eg I have employees years of service and I want to add a group such as 1-5 years 6-10 years...

I have a row of data where each cell is using a VLOOKUP formula - the formula either returns a number or "-". I need to count all the cells that contain a...

Is it possible to add 5+5+5 in one cell and hit enter? Just trying to avoid using a calculator. -- JW

Hi - I am created my combobox using activeX control. In the linked cell properties, I specified the cell. When I select an option in the combobox I want...

My problem is that hyperlink will not allow you to use the absolute function (ex. $B$12) like in =$A$2+$B$4. So that where ever you drag the numbers to a...

Hello All, I am seeking advice on a formula to give me a count of work order types. I have already spent a few hours getting "close" but not close enough...

I have a database and i want to summarize how many of certain products were returned. my dilemma is that i need to reference a cell that only lists the style...

Hi everyone, Hoping you can help me. I am using Excel 2003 and trying to insert a couple of simple formulas that I use continuously in spreadsheets. But I am...

Is it possible to freeze one row (say, row A) and multiple columns (say, columns 1, 2, 3, 9, & 15) where the frozen columns will stack under each other as...

How would I use the FV function for compound interest on an investment maturing in 30, 60, or 90 days? So, for example, where would I plug in the following...

Hello, I am trying to use conditional formating to select multiple rows, but skipping some rows and than coloring the body... Example: If cell A1 is...

How can you link from excel 2007 to a specific slide in PowerPoint 2007? This work in the older versions by just puting a # and the page number. Now it's...

Okay, here is a question. I have a single spreadsheet that I am using for a mailmerge. However, I am getting an #N/A error that I cannot explain. I have...