HI, Name - Harmeet Tip - Calculate formula using F9 Detail : Lets say you have a formula : =IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1)) in order to calculate partial formula you need to select desired formula like this: =IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1)) Then press F9, it will convert the formula to value. Then press Ctrl+Z to revert the change (If required)
Benefit - For long formulae user can verify the result for subformula of main formula. For explanation see attached screenshot......... On Sun, Jun 21, 2009 at 8:49 PM, Ayush <jainayus...@gmail.com> wrote: > > Dear Members, > > Thanks for your great response in the Week 25 competition. It was > again great learning for the members of the group. > Let us begin week # 26 quiz with the more spirit. This is last chance > for you to be eligible for June month competition.The winner of week # > 25 will be declared soon. Keep watching this Space...... > > Last Date of Submission of tips : 28th June 2009. > > PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE > CONSIDERED FOR PRIZES. > DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. > > You need to submit your name, Subject & the details of tips and > tricks. > DO let me know if you need any clarifications. > > Let me begin by submitting the first tip for this week competition. > > --------------------------------------------------------------------------------------------------------------------------------------------------- > Name : Ayush Jain > Subject : Format Painter > Detail : The little "format painter" is the most useful button in > Excel. It looks like a paintbrush and is grouped with the > cut,copy,paste buttons. Basically highlight a cell with the formating > that you want, click the button, and then highlight cell(s) that you > want to just paste the format. HUGE time saver! > > Who is next ???????????????????? > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<attachment: tip2.png>>
