I have an Excel workbook with more than 30 sheets. I want these sheets to be sorted in alphanumerically order. Following is the macro that has resolved the issue.
Logical test means a condition when evaluated by computer whose result/outcome is true or false, there is no third option, for example if a student secures more than 45 marks it is considered as pass otherwise fail.
In Excel a single IF function (IF(logical_test, value_if_true, value_if_false)) evaluate only one logical test at one time, if we have more than one conditions/logical tests, then we use AND function or OR function along with IF Function.
Sometimes we need start date and end date of a month for our financial model. We can solve this problem by using EOMONTH Function.