Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Excel can understand each of these formats. Since you already changed the cell format, Excel calculates the day of the week, which would be Sunday for the previous example.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

Easy way to calculate time difference in Excel using simple logic. A simple formula to calculate difference between two dates & times in Excel.

How to Calculate Negatives in Excel. Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected ...

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.