I need to know when I do a vlookup its not pasting the formula but when I go to save the spreed sheet it changes the fields to correct material descripion.

When referencing an empty cell, like in 'Sheet A'!B3:B6 from Sheet B, instead of displaying an empty cell as well, I get a 0 in it. How do I get rid of this...

I am trying to create an IF function for a spreadsheet. What I want the IF statement to do is to look at a column, and depending on what is in the column,...

I have searched these postings and can not find my answer. If someone can point me in the correct directions I would really appreciate it. I have six...

Hi everyone, I need some help with this please; I am using Excell 2007 Worksheet contains 6 cols, T,U,V,W,X and Y and another col AG in a small recap table a...

I have a button control in an Excel form that users can click on to email the form to another user. I would like to know if there is a macro that I could...

Folks, If I cut and paste my "timesheet" from my Excel Calendar I get the following column of values for Duration: 1 hour 1 hour 1 hour 1 hour 1.75 hours

I downloaded an expense spreadsheet and it shows the charges as positive and I need to change these numbers to negative. There are up to 150 numbers in a...

the result of my hlookup is #N/A as my formula reads: hlookup(A1,A2:A6,1,false). Question: How do I make this #N/A invisible? I would rather see a blank cell...

In Excel, I want to be able to enter a date in one field and have a date that is 1 year later in the field next to it; what formula may I use to achieve...

Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final...

WASHINGTON - Congressional leaders and the White House agreed Sunday to a $700 billion rescue of the ailing financial industry after lawmakers insisted on...

Would appreciate help with this request: I have two sets of numbers in rows: eg: 2,10,16,20,38,39,42,45 3,10,15,32,36,38,40,42 I want a function that would...

I have a workbook with two sheets, sheet2 is a data sheet and sheet1 is a summary of information from sheet2 which performs calculations on information from...

Hi, there. I found that the "Design" manual was disappeared (or gray out when added a new command on the quick access tool bar) after I exported the...

This macros below allowed me to insert a picture that I choose into Cell G1 at the correct heigth and with in 2003. Now in 2007 it does not put it into the...

=EXP(1)

I am using a Custom Sales Order Template. I use a macro to clear contents (from previous sales order). I use SUM formula in the TOTAL cell and wonder if I...

Hi everyone, I am trying to setup a excel sheet to calculate sales reps commissions, the more they sell the higher the banding becomes. 6500 profit = 5%...