$$Excel-Macros$$ Re: Formula to add date

2011-01-12 Thread J D
I am no whiz kid with Excel but use it all the time. I usually just put a date in a cell drop to the next one and add 1. A1 would be the date formated how I want, A2 would be =A1+1. I then copy and paste that down the column or acroos a row. I have one spreadsheet that covers the year. I just u

Re: $$Excel-Macros$$ Nested IF functions?

2010-12-29 Thread J D
Nested IF functions? > From: dilipan...@gmail.com > To: excel-macros@googlegroups.com > > Hi J D, > á > It would be really appreciable if you can share a test file on this.á Help us > to help you :) > á > Best Regards, > DILIPandey > > On Tue, Dec 28, 2010 at 7:36

Re: $$Excel-Macros$$ Nested IF functions?

2010-12-29 Thread J D
ing 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" &

Re: $$Excel-Macros$$ Nested IF functions?

2010-12-29 Thread J D
Tried to but was blocked from doing so. That is why I pasted what i could. On Dec 28, 9:48 am, Dilip Pandey wrote: > Hi J D, > > It would be really appreciable if you can share a test file on this.  Help > us to help you :) > > Best Regards, > DILIPandey > > > >

$$Excel-Macros$$ Nested IF functions?

2010-12-27 Thread J D
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 producti

$$Excel-Macros$$ Estimating with Excel

2010-06-12 Thread J D
I am an estimator with a concrete company. I build new spreadsheets for every bid. A lot of this is repetitious, same basic line item again and again, just the square footage might change. For a better idea of what it looks like: Furnish and install ~7,010 s.f. of 4" concrete wearing slab for n