Hi Dtenz, I think this task can easily be done by using Excel formulas. Attached is the sheet for your reference.
Please let us know if you need further assistance. Best regards, Ayush Jain Group Manager On Mon, Jul 5, 2010 at 3:41 PM, dtenz <[email protected]> wrote: > Hi, > > I am new to excel programming. I am having a little trouble trying to > write a small code. If I can do it, it will save me a lot of time as > i need to repeat the same procedures for different files. > > I have name cells A1 to D1 as Number Num1 Num2 and Num3. Now I have > data in Col A from A1 to around A500 depending on the file. What I > need to do is: If Number is >=25, then Num1=25 and If Number is <25, > then Num1=Number. > For Num2: if Number-Num1>=25 then Num2 = 25 else Num2=Number-Num1 > For Num3: Num3=Number-Num1-Num2 > > The cell I am trying to calculate will be B2 and rest of col B = Num1, > C2 and rest of col C = Num2 and D2 and rest of col D = Num3. > > Thank You, > dtenz > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Best regards, Ayush Jain -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
dtenz.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
