Yes it's very clear now. Try any one of the below formula which will do the trick.
=IF(ISNUMBER(A3),IF(A3>1000,2.5,IF(A3>=500,3,IF(A3<500,3.5,""))),"") OR =IF(ISNUMBER(A3),IF(A3<500,3.5,IF(AND(A3>=500,A3<=1000),3,IF(A3>1000,2.5,""))),"") At the same time herewith I have attached a sample file for your reference. ----------------------- Ms.Exl.Learner ----------------------- On Wed, Dec 29, 2010 at 11:13 AM, J D <springer...@gmail.com> wrote: > Thanks. I have the Syntax correct now but how do I end it. I want to > write a formula that would return the right answer for the below. > > if A3 < 500 value will be 3.5 > if 500<A3<1000 then value will be 3 > if A3>1000 then value will be 2.5 > > I entered =IF(A3<500,3.5,IF(500<A3<1000,3,IF(A3>1000,2.5)))) and got > False for an answer. I want to type into A3 a s.f. number and have > the formula kick out one of the 3 or more possibilities so I can use > the correct value in the next equation. > > Hope this is clearer. > > Thanks > > > > > > > On Dec 28, 4:29 am, hanumant shinde <arsfan2...@yahoo.co.in> wrote: > > 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 athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://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&...-Hide > quoted text - > > > > - Show quoted text - > > -- > > ---------------------------------------------------------------------------------- > 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
Example Workbook.xls
Description: MS-Excel spreadsheet
