IFS Function
With IFS Function you don’t need to deal with nested IF functions anymore. IFS is an if function that can take multiple conditions.
Tagged: if function
Create Custom Zebra Lines
When you have to deal with lists that has a large number of rows, zebra lines can make spotting changes in the data much easier....
Website Like Ratings
I was looking for hosting solutions for beatexcel when I saw ratings for hosting companies on almost all affiliate sites. I wondered whether we can...
How to Block Data Validation Override
You can setup a data validation list to limit entry to certain cells. But you will realize at some point that your data validation can...
IF AND OR Function Combinations
Do you need to use a logical condition in your formulas? Do you need functions like between but can’t find it? This post will show...
