MS Excel is a repository of a wide range of formulae that help its users to compute calculations across a diverse set of fields from Engineering to Economics for example. But within each of these formulae is a fundamental structure that renders it functional in the first place. This fundamental structure is called a ‘Syntax’ …
Ever searched for something, but couldn’t find it anywhere in the places that you were looking for? The same might happen in MS Excel too! One can search for a particular entity, be it a text or a number or a date within a table, only to find out that it was never there in …
Machines & humans don’t speak the same language. Even the very imagination when filmed leads to mass-scale destruction (We all would have watched at least one film from the Terminator series). Also read: How to Fix #REF Error on VLOOKUP in MS Excel? But here’s the catch! Humans don’t do well when it comes to …
Formulae are great in-built features in Excel which deliver results of humungous computations in a matter of seconds. But that doesn’t guarantee delivering the correct results every time. There may be times in which errors of some sort shall take up the very place where the results are to be displayed. Errors of such kind …
Appearances are deceptive! That is especially true when it comes to the data that is in Date format in MS Excel. Though a date may appear in the DD-MM-YYYY format or fancies any other format for that matter, deep underneath MS Excel assigns a value to this date. To put it in simple terms, dates …
We would all have gazed at the skies & tried to count the stars at least once in our life. Counting seems to be an obsession for humanity and that explains the origin of sayings such as ‘Don’t count your chickens before they hatch!’. We always need to have track of things & counting them …
It is such a blessing to have formulae as a built-in feature in MS Excel, but that doesn’t guarantee to deliver the correct results every time. There may be moments of derailing which would lead to errors taking up the very place where the results are to be displayed. Errors of such kind are numerous …
You can add a group of numbers listed in a spreadsheet without breaking a sweat, but what if there comes a stipulation amidst this task? How about a list of positive & negative numbers and the task in hand is, to sum up only those which are positive! Now how do ya’ like it? Also …
The important selling point of MS Excel back in those days was its ease in using formulae and it stays that way to this very day. We can refer to the data in any cells & build umpteen formulae in MS Excel in such a way that the results of the formula get updated the …
$ in Formula in MS Excel – What Does it Mean? & Examples of Usage Read More »
Formulae are a great feature to have in MS Excel, but at times we don’t need the constructs of the formula within the cells to be retained, instead only their results! What shall one do on occasions like these? Is there a way around it? We shall explore just that in this article using the …