-
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<...
-
Harness the power of the suite of Text functions, such as LEFT, RIGHT, MID, FIND, LEN, TEXT, and REPLACE, and you'll be an unstoppable force. In this post, experiment with these functions and build your skills in finding, extracting, and changing text in worksheet cells. ...( read more )
-
By now, you've gotten used to using digital calculators, such as the one in Windows or in your phone, and you know their limitations. Say you want to calculate mortgage interest or your grade point average. This is where it's time to make the move to Excel and see how it's a vast improvement...
-
We've noticed some of you searching for help using "$" — a dollar sign. In Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. In this post, we'll talk a bit about both uses of the dollar sign. ......
-
Are you confused by how Excel handles percentage formatting, or by percentages in general? It's okay, you're not alone. In this post, find out more about how Excel displays percentages, and learn basic techniques for calculating percent decrease, percent increase, and percent change. ...( read...
-
There are times when one wants to extract the last part of a string, say the file name from a string that contains the filename including the path. This short note describes a few ways to do that.
The example we will use is the following. Cell A1 contains the value c:\x\yz.jpg. What [...]
-
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...