Access and Excel

[Madcowz]

Hello all.
Hopefully I can explain and ask this question correctly... So I have finally figured out my Excel spread sheet problems, almost anyways. So right now I have my sheets sheet up to return a value under a specific date. For example, I have an employee booked to work on my daily schedule (Sheet 1)for Jan 15. On sheet2, I have the days of the month across the top (cells A1 to AG1), employee name from cell B1 to B52. So when I plug my worker in to a spot on Sheet1, it automatically input "worked" under the Jan 15th cell on sheet 2 and it works great . My only problem is, on Jan 16th, it will show that the employee has worked in the Jan16th cell, but the jan 15th cell now shows he was off, basically not saving the previous days info. So my question is, Is this where creating an Acess database would come in handy, so that my previous days info will be saved and not reset?

 

[Madcowz]

Ok pretty sure I understand a little better, so for example, if I put =IF(C2="1","1","0") in say Cell D2, and the # 1 is present in cell C2, Cell D2 should show the #1 correct?, if the # 1 is not present, then it should show a 0

 

[skywriter]

Ok pretty sure I understand a little better, so for example, if I put =IF(C2="1","1","0") in say Cell D2, and the # 1 is present in cell C2, Cell D2 should show the #1 correct?, if the # 1 is not present, then it should show a 0

That's correct, but just to clarify you would not have "1", this would mean you are looking for the text "1", not the number 1. I'm pretty sure you just put the "" to highlight what you are talking about.

=IF(C2=1,1,0)
If the C2= the number 1 then return the number 1 otherwise return the number 0.

You can do whatever you want, here are some other examples.

=IF(C2=1, Sum(A10:A22),A12+A22)

IF C2=1 then give me the sum of cells A10 through A22, otherwise add A12+A22 and give the results of that math problem.

=IF(C2=1, Sum(A10:A22))

In this instance I didn't not specify what to do if C2=1 is not true so if C2 did not = 1, then the result of the formula would be the word FALSE in the cell where this formula resides.

 

[Madcowz]

Thank you very much for all the help, I am going to play around with it some more, I am sure I will have a few more questions yet.

 

[skywriter]

Thank you very much for all the help, I am going to play around with it some more, I am sure I will have a few more questions yet.

Okay, good luck, you are welcome.
You might want to start a new thread if you need any further help.

 

[Madcowz]

Ok will do. I gave up trying to set that up that schedule, it just won't save the previous dates info no matter what I do lol, so on to my next project.