Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on that particular single input (or more) So, i learned a trick, it is formatting the entire sheet to certain color and give that cell special format to make it look […]
Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a certain cell Not any more
I tend to see more and more the usage of nested IF functions recently Now, do not get me wrong, IF is great, but come on, are you going to use it for more than 2 conditions? seriously? Excel 2013 comes with IFS, the perfect alternative to nested IFs As you can see, takes up […]
Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can do magic
Guess what I just found in my old archive !
The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round number to any value up Unlike ROUND, ROUNDUP and ROUNDDOWN, that are limited to number of decimal places. CEILING can round to any number, decimal or not. Below is an example of rounding the number in […]