I am using Excel 2007 and need some helping on a rounding formula. I would like my cell to either round to the nearest whole num or ".5" of the number but...

Is it possible to have a list range in one cell based on the inputed information in that cell? IE, I have a packing list for 3 different products, and 3...

Having problem in displaying number! A1=25.25 (outcome of some calculations, formatted as number with two decimal places) In A10, I am trying to display...

I am trying to update my data range in a nested array function without having to change every cell. Is there a way to change the entire data range within the...

Hi I have created a VLookup formula which returns the information I require it to. However, I need it to go a step further. For instance. I have asked it...

Dear All, I am writing a massive IF statement and i have nearly got it to work but i need help with the last bit. I have a got a price list for shipping with...

I would like to find if the cell value of A1 exists in table A2:AA450 I have tried with ISNA and Match but Match does not seem to work as I have more than one...

I need a little help figuring out how i can display a cell (I28) if cell (G28) is yes. The current formula that is working for me now is...

Hi Why am I getting a #VALUE! error in the following. =SUMPRODUCT(--(D25,F25,H25,J25,L25,N25,P25"")) Thanks if you can help Gotroots

I am attempting to display information from another workbook. Now I am able to get this information displayed and all the information is displayed correctly,...

I smxlsx but an error message comes up requiring I save with a format compatible with the use of macros. The file has several vlookup and if statements, but...

I am working with 3 worksheets in the same workbook. My worksheet tabs are labeled: 9C moinfo slsbudg I am trying to create a formula in the cell...

I have the following formula in one of my cells: =IF(C50,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" Calculated value") The values in C4,...

Hi, I have data where columns have headings but rows are blank. I have approx 500 rows of data. ID Student Course 1 Course 2 2 Tom ...

Hi, I read in a post on this site (by Niek Otten in July 2009)that we can have problem with the Indirect function in Excel when we work with people with...

How do I link an item (letter, symbol) to another worksheet within the same workbook then be able to double-click on the item and it take me to that item....

First I want to say I have read many posts and tried many suggestions on those post before posting my question hoping I wouldn't have to ask a question that...

Good morning, Is there a way I can populate a "packing list" in one tab from a "master part list" in another tab? I would like to select quantities from the...

Hard to explain what I need, but I have a complex worksheet full of conditional formatting and linked data. I need a way of 'anchoring' a number of rows...

I want to show a result of a formula contained in another workbook. This should surely be a simple formula such as: =A!$AA$11 I am getting zero returned...