Functions

Using Iserror with If statement and Vlookup
I have the following formula in a cell: =IF($K2="STEEL",VLOOKUP($B2,'Macos 12 Mo. Data'!$A$4:$AU$326,40,FALSE),0) Problem is that the results of this are used for calculations and K2 sometimes doesn't equal "STEEL" so I get an error. I've tried putting an Iserror and have the error = 0 but am doing something w... 12 Mar 2010 10:33

Help with SUMIF & AND function
Hi, how do I create a formula to sumarize value by group and subgroup? My formula by group works but unfortunately the 2nd one doesn't work. What I need is : sumarize the value (column D ) of all products having group = A and subgroup = A. total group subgroup value by_gr by_subgr A A 10 A A 20 A B 30... 12 Mar 2010 10:33

Excel file size increased 3 times after saving!!!!
Hi all, I have a very strange situation with my Excel workbook. I created Excel workbook with conditional formulas (no other formulas) which total size is 3 Mb. After I put simple data for calculation and saved the workbook the size increased to 10Mb! The data itself is just about 70Kb. I use Excel 2002 at w... 13 Mar 2010 11:58

Consolidating Data Between Worksheets with Duplicates Removed
I am interested in tracking lab values that my staff enter into a daily worksheet. I would like to compile monthly percentages (% low, % in range, % high) but sometimes it is necessary to have duplicate data on consecutive worksheets for my staff's workflow. These duplicate values will cause my percentages (a... 12 Mar 2010 20:43

Return Corresponding Value Based on Comparing Two Sheets of Data
Can someone please help me find a formula (or two) for this example. If you can show me a couple of ways to do this (so I can learn), I'd greatly appreciate it! Thanks! I'm trying to figure out a formula (or two) that will help me auto-populate the ? fields within ColumnB of Sheet 2. Also, I want the ? value f... 12 Mar 2010 00:42

slope?
Hi, if I have the following table how do I find x? 1 1134.9 2 3 1138.99 4 5 x ... 12 Mar 2010 00:42

Check to see if a value exists in a list?
Hi and thanks again for your help out there... Is there any function to test if a particular value exists in a list? A simple example: Column A1= car; A2=train; A3=plane In B2 I place "car". Is there a function which will return TRUE if B2 exists in A1:A3, or false otherwise? Thanks Pradhan ... 14 Mar 2010 09:48

Why won't this function work?
This function works: =IF(B71="","",IF(B71<=330,"Standard","Below Standard")) But when I change "330" to "R4" it doesn't work. R4 is a number field that has 330 in it. It doesn't seem to be recognizing the Value_if_False statement. Any number will make it show "Standard." =IF(B71="","",IF(B71<=R4,"Standard","Be... 12 Mar 2010 00:42

SUMIF or SUMIFS help
I have 2 sheets in one workbook (Sheet 1 and Sheet 2) Sheet 2 has 3 columns: A B C MAKE TYPE QTY 1 toyota compact 10 2 ford pickup 15 3 toyota sedan 20 4 toyota pickup 80 5 nissan hybrid 10 Sheet 1 has 2 co... 11 Mar 2010 20:15

Countif function
I need to find out how this countif works. In my excel class I did the countif like this. Statistical, countif, I selected the range, press F4, tab and with insertion point in the criteria box I clicked the cell that was needed. It came out really well. However, when I had to do the skills review, I did exactl... 11 Mar 2010 18:01