-
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"...
-
I am wondering if anybody can help me. I was always under the impression that it was not possible to convert formulas in excel into another language, but now I have found a website ( http://www.mytongue.biz ) that has a downloadable add-in which they claim will allow chinese excel users to use a thing...
-
mmmm.... From the Excel 2007 help file Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. (See Example 3 for a sample of nested IF functions.) Does anyone know whether it is 32 or 64, or does it matter anyhow
-
Matthew There are some contradictions in your criteria, e.g you have >3 and <3. What happens if it is 3? I have allowed for some of these but anything over 1 will get a proper case Slow Moving and anything below or equal to 1 will get an all lower case 'slow moving'. (That would be too...