Hi, I have not any formula but just a tip to reduce your finger work on keyboard.
We know that IF() function is one of the function use in many cases. But How to solve a problem with this function. Sometimes it is difficult to write the formula due to multiple use of IF(). IF() produce one output from two values depends upon the condition. I said Values________Output_________IF() Used ___2___________1_______________1____ Means One IF() used for generating 1 output from 2 values. What if there are three values and we have to choose one. Then find One result from first two values then find the output from the last value and the result value. Means we have to use 2 IF()s for this. e.g. If A2=5 print "HI" A2=6 print "HIIIIII" A2=7 print "Hiiiiiii" then IF( A2=5 , "HI" , IF( A2=6, "HIIIIII", "Hiiiiiii")) Thus Values________Output_________IF() Used ___3___________1_______________2____ Similarly in many cases we need just one output from many values say "N" and it is possible to find the solution by using "N-1" IF() functions. Values________Output_________IF() Used ___N___________M_______________N-1____ So don't get lengthy on if formula just use your mind to find the best solution. Sandeep On Jun 23, 10:18 pm, Harmeet Singh <harmeet.hew...@gmail.com> wrote: > 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 Tue, Jun 23, 2009 at 10:43 PM, Harmeet Singh > <harmeet.hew...@gmail.com>wrote: > > > > > 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 > > -- > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > tip2.png > 10KViewDownload --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
