I have a column containing currency values. I want to multiply the values by the current exchange rate which i will input on another sheet to give me the new...

I want to create a sheet which will serve as a Proforma Invoice displaying data from a Bill of Materials sheet within the same file. For any line item where...

Please help. I have "input" data like this: AA BB AA DD CC -------------------------------------------------------------- 8 ...

I've used SUMIF for simple calculations such as: SUMIF($F$32:$F$39,"Contracted",$H$32:$H$39) on a single sheet. How would I work that using INDIRECT to...

In my file, i have a separate worksheet for each day of the month (1, 2, 3, etc) that has a bunch of lines with a total in (let's say) row 10. In the last...

I am trying to set up a chart and instead of using "yes" or "no" for answers, I'd like to be able to use checkmarks. Is that possible?

Hello, is there any function with how i can my send the curent worksheet to a preseverd person - like i make a sheet with a button , when i click the button...

1. Select all cells by clicking cell in top left corner 2. Right-click 3. Select the option that turns off autoformat. I rock! Dave "Dave a.k.a....

I have a spreadsheet that contains references to 400 Approx items. I also have a generic word document that I need to input the 400 references into....with me...

Hi does anyone know how I can replace a page full of cells with formulas pointing to cells in another workbook with the numerical value of what is currently...

I am building a spread sheet to calculate the triangles for the setting out stations for various sites and wish to work in grads i.e. 400degrees per circle...

After a range has calculated the answer from a formula, how can I change the same range to the value displayed?

I’m looking for a formula to convert distance. Example: 60.625 to 5’ 3/8� Is this possible? Can someone help me?

OK...I've tried consulting many boards to get around the nested if limit in Excel 2003. I remember seeing something about concatenating strings together, but...

Well, after hunting on here for suggestions for how to create my own ratio formula, I ended up (through trial and error and testing) manufacturing my own...

I have a 450 record listing that has five columns in it, of which, column C is "Location". I also have a named range in Column J called "ClosedLocations". I...

Is there a way I can, in the first worksheet of 40, type in a cell a function that will return me the name of another worksheet? I know how to return...

I have a huge spreadhset (and a deadline!) that VLOOKUP will find several matches for the lookup_value. Each may have a diferent value at the range_lookup. I...

I'm trying to create a workbook that queries financial data (multiple tables) from MSN. I can get the data queried just fine into different worksheets, but I...

I'm trying to work out how to calculate the number of days a person has taken off in a running twelve month period. For example if a person had been off 2...