-
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...
-
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
-
This post is all about IF--not the poem by Rudyard Kipling, or the 1971 hit song by Bread, but the function . The IF function is used in many Office programs, but most of us know it from Microsoft Excel: IF(logical_test, [value_if_true], [value_if_false]) IF is one of the most searched-for words on Office...