-
Hello, New to the site. I have a formula question I am hoping someone can help me with. Would be greatly appreciated. I need to do an if formula that accomplishes the following. I need to multiple to number sum(s50*09). If that sum is less than the number in cell (i50), use it and put it in cell (o50...
-
I inherited an EXCEL sheet that has the following formula as a rule for the conditional formatting of a group of cells: =NOT(#REF!=3). I have tried to find what values #ref! can take on but have not been at all successful, Can anyone say what values #REF! can have and what they mean, of just what the...
-
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...