-
I have an excel spreedsheet that factors what my reps sell based on a goal and what they have actual. It then takes that info and percentage and applies it to weight provided to give an overall percentage ex. =IF((E2/D2)>1.5,1.5,(E2/D2)) What im trying to do is set up a new formula that takes what...
-
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 a column with numbers that all start with 7 and i want to change all of them to 8 ex 711256 712345 711666 can anyone give me an idea on doing this thanks in advance
-
I have the following data strings in each cell: M1.M17.M49.M203.M205, M1.M17.M78.M190, M1.M4 I need to separate the data after the last period in each cell. I am using: =RIGHT(H2,FIND(".",H2)-1) but get only the last two digits in each case. Help!
-
Is there anyone there that can assist with an elegant and accurate way to calculate the age of a person using the current date stored in one cell and a person’s birthdate in another cell? I am trying to calculate and display a person’s age in years only as of the date entered into the Current...
-
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...
-
There is a general approach to this for odd and even numbers of teams. I have a spreadsheet that does this and calculates schedules in a couple of different ways. However it is open office and may be a little different from Excel (see http://templates.services.openoffice.org/en/node/4035 ). There is...
-
I have a sheet containg two columns, frmatted as currency and to show negative numbers ehere approriate. e.g -£25.00 One colum shows a positive number of £3.00 (Cell A1) whilst the other shows -£1.00. (Cell D2) When I do the =SUM formula as =SUM(A1-D2) I get the result of £4.00...
-
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"...