-
Curtis, Thanks for the formula... Put it in and it seems to work somewhat...a value is being returned. There is a problem, though...maybe I am doing something wrong.... What it is doing is that no matter what cell number I put in for A or B, the value returned is always Z1. Any thoughts what's going...
-
To whom may be able to assist. I am currently working on defining a function/automated process for generating sample intervals from a data set of intervals created from a drill hole. The data that has been captured is the 'rock type' and can stretch over 0.1-10's of metres. When sampling...
-
Hi All: Looking for some help on this: Here is what I put in for the formulate but I get this error in my AS INITIAL OFFER BOX: #VALUE! Here is what I have for the formula to start with so far but it is not working (once I got it working, then I was planning on addition other ranges): =IF(AT1<3499...
-
I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work. =IF(OR((AND(V7*0.95<...
-
I need to compute the five year final average compensation for a person with year one being the base year and years 2-6 being the five years where the average is taken. Each year has a maximum cap of a 10% salary increase allowed from the previous year. Furthermore, some years the person may not earn...
-
I have 3 sheets in my excel document. The first one is the main form and the other 2 are summaries that need to be populated and distributed the correct person depending if one value on Sheet1 begins with a letter between A-O or P-Z. What I need on each summary sheet is this sequence: On Sheet 2 in Cell...
-
This is my question/issue – I am trying to create an estimating tool for software projects. Based on 3 or more project types (A, B, C) the three major roles (business analyst, developer and quality assurance) have different level of efforts (time they will spend on the project). I created the following...
-
Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size | Ball Valve, V600, 02 | C12DO | F1804B | CARBON STEEL, PIPING | 12 | EA | 1" | Im trying to use the "Description" & "WBS" columns for the criteria to match...
-
Excel 2003. We are capturing grades for site reviews based on the scale listed below. On the report we need to indicate how the current grade compares to the grade from the previous period. Score Grade 1 F 60 D- 64 D 67 D+ 70 C- 74 C 77 C+ 80 B- 84 B 87 B+ 90 A- 94 A 97 A+ If the grade improves or declines...
-
Please any1 evaluate and let me know where i am going wrong. All cells produce an OUtcome of J regardless of the amounts being evaluated. Using Excel 2007 =IF(F18<3579,"A",IF(F18<4349,"B",IF(F18<5299,"C",IF(F18<6089,"D",IF(F18<6969,"E"...