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
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
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"
&
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
>
>
>
>
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
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