After calculating values in Excel, you can copy and paste the results into a finalized rate card document. Functions and Operators Excel provides several options for calculating financial values ...

Now, let’s use Excel’s RIGHT() function to extract the last two characters from each value. To do so, enter = RIGHT([@Department],2) into H3 and copy to the remaining cells.