It is optional. In Microsoft Excel, there are three types of match_type 1,0,-1. The “1” match_type finds the largest value that is less than or equal to the look_up value.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to fix the issue.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Thanks -- and Fool on! 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 .