Excel Tips
Tiered Commission Plan with IF »
March 22, 2022
I am calculating a commission based on a sliding scale. The rate is based on the size of the sale, using the table shown here.
March 21, 2022
The CFO decided we should only pay the 2% bonus if a second condition is met. The GP% must be 50% or higher in addition to the sale being over $20,000.
March 18, 2022
My VP of Sales announced that we are paying a 2% bonus for all sales over $20,000 this month. How do I calculate the bonus?
Format Every Other Row in Green »
March 17, 2022
Got any cool uses for MOD? Got any old-school methods for applying the greenbar format that was in the Excel 2003 AutoFormat dropdown?
Find the Second Largest Value »
March 16, 2022
I can find the largest and smallest numbers using MAX and MIN. I am trying to identify the largest and smallest three numbers. How can I find the second largest number?
XOR Only Works Correctly for Two Values »
March 15, 2022
Excel 2013 introduced an Exclusive OR (XOR) function. It won’t work correctly for more than two values.
March 14, 2022
I need to convert units of measure. I can never remember that there are .453 kilograms in a pound or 2.54 centimeters in an inch.
Help Your Kids with Their Math »
March 11, 2022
My kids have math homework, and I want to check their answers. They are doing least common multiples, greatest common denominators, Roman numerals, and factorials.
Figure Out Lottery Probability »
March 10, 2022
The Super Lotto jackpot is $8 million this week. Should I play?