Excel formula helper |
|
In our everyday usage of excel, we
often come across a situation where we know which worksheet function to
use however we don't know the function arguments properly. We
therefore make use of the either the Paste function or
locate the appropriate function in the Excel Help file by pressing F1. Excel
also provides another neat feature the Excel Formula Helper which
saves quite a bit of time. Let us see how to use
it...
Type the name of the function like this "=IF" (Please do not include the quotation marks), press Ctrl+Shift+A. Excel will automatically display the function arguments required. Just replace these with the required cell addresses/values |
