SUMIFS Function in Excel: Sum With Multiple Conditions
SUMIFS adds values where all conditions are true — the backbone of formula-based reports.
Read article →VLOOKUP Approximate Match: Tax Slabs, Commissions and Grades
VLOOKUP Approximate Match: Tax Slabs, Commissions and Grades
The TRUE in VLOOKUP is not a mistake: approximate match is perfect for slabs and bands such as income tax, commission rates and exam…
Read article →SUMIF Function in Excel: Sum Values That Meet One Condition
SUMIF Function in Excel: Sum Values That Meet One Condition
SUMIF adds values where one condition is true. For two or more conditions use SUMIFS.
Read article →Time is Greatest Gift
Time is Greatest Gift
“Time is your most precious gift because you only have a set amount of it. You can make more money, but you can't make…
Read article →Stop Crossing Oceans for People
Stop Crossing Oceans for People
There comes a time when you have to stop crossing oceans for people who wouldn't even jump puddles for you. Why this idea…
Read article →Phantom Vibration Syndrome
Phantom Vibration Syndrome
Phantom vibration syndrome or phantom ringing is the perception that one's mobile phone is vibrating or ringing when it is not. Other terms for…
Read article →Laughter is Panic Response to Tickling
Laughter is Panic Response to Tickling
Most of us have a ticklish spot somewhere on our bodies, and it is usually pretty easy to find. For some it's just above…
Read article →Oxytocin reason for Alcoholism and Drug
Oxytocin reason for Alcoholism and Drug
It turns out oxytocin is responsible for a lot more than just love. New science has found that this amazing molecule also influences how…
Read article →MIN Function in Excel: Smallest Value in a Range
MIN Function in Excel: Smallest Value in a Range
MIN returns the smallest number in a set of values, ignoring text and blanks.
Read article →TODAY Function in Excel: Current Date That Updates Every Day
TODAY Function in Excel: Current Date That Updates Every Day
TODAY returns today’s date and recalculates whenever the workbook changes or opens. NOW adds the time.
Read article →LEN Function in Excel: Count Characters in Text
LEN Function in Excel: Count Characters in Text
LEN returns the number of characters, including spaces.
Read article →MID Function in Excel: Extract Text From the Middle
MID Function in Excel: Extract Text From the Middle
MID returns characters from the middle of a text, starting at a position you choose.
Read article →