| 
		 OfficeTips Home || VBA Section || General Section || Download Section || Privacy Policy  | 
	
        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  | 
    
Copyright 1999-2018 (c) Shyam Pillai. All rights reserved.