i dont understand what u mean exactly but i will jus tell u abt nested if in excel. let me know if you wanna know nesed if for Macro.
it is if else function. so write if and give some value if is its true and in place of else write another if. if you wanna know the syntax refer help in excel. just type in IF and you will get everything there. e.g. =IF(A3=3,"Equal",IF(A3<3,"Less",IF(A3>3,"Greater"))) explaination if A3 = 3 value wil be "Equal" if A3<3 then value will be "Less" if A3<3 then value will be "Greater" ----- Original Message ---- > From: J D <springer...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tue, 28 December, 2010 7:36:57 AM > Subject: $$Excel-Macros$$ Nested IF functions? > > I am a concrete estimator who is trying to create some cut and paste > Estimate line items I can just grab from one spread sheet and paste in > to my estimate. > > I was refining one and tried to use the IF function to pick the number > of labor hours based on sq footage. More s.f. and we are more > productive therefore less hours per s.f. > > I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to > 1,000 then .0275 hrs/s.f. >1,000 s.f. then .0225 hours/s.f. > > I could get one working but wanted to know how to get more going > choises out of one formula. Attached is the assembly and the formula > below it. > > > Form, place and finish ~ (__) s.f. of 4" broom swept finish concrete > sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ > w1.4 wwf. $4,410.00 > Area 990 s.f. Perimeter 114 l.f. > Concrete 990 0.33 1.03 336.501 12.463 13 145 1885 > Labor 13 0.4 5.2 5.2 40 208 > wwf 990 40 24.75 25 7 175 > 2" SB 990 0.26 257.4 260 0.49 127.4 > Labor 990 0.003 2.97 3 40 120 > Poly 990 1800 0.55 0.6 85 51 > Labor 990 0.002 1.98 2 40 80 > Expansion 990 0.25 247.5 100 2.475 2.5 31.64 79.1 > Labor 250 0.01 2.5 2.5 40 100 > Curing 640 350 1.828571429 5 0.365714286 0.4 55 22 > Labor 990 0.003 2.97 3 40 120 > 2 x 4 114 16 7.125 8 5.81 46.48 > Labor 114 0.33 37.62 0.2 7.524 7.6 40 304 > Finish 990 100 9.9 2.75 27.225 27.3 40 1092 > > > > 4409.98 > =IF(B16<500,3.5,2.75) > > -- >---------------------------------------------------------------------------------- >- > 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
