Multiple Arguments

I am trying to restore a template that an employee typed over the fomulas. The creator of the document no longer is employed with us, and since I know very little about excel, I hope someone can help me with this. I was able to get the formula to work in some of the columns but others don't work. On Column G & H this person has three days of instead of two so I tried to enter a third augument in the formula, but that does not work. On the documents that were not password protected I found two different ways the days of the month are populated Column B & C. The swings tab is the easies to change but it gives an #value error. The days tab works but if the user does not understand excel fairly well they may have a hard time updating the form each month, and again some of the column are not reading the formula. Hope this all make since.
OT-Signup-for-Supervisors--May-2.xlsx
poucedeleonAsked:
Who is Participating?
 
poucedeleonAuthor Commented:
Found the problem to be the type of data.It was entered as text instead of a number.
0
 
SiddharthRoutCommented:
I think this is what you are trying to do, Correct me if I am wrong?

Copy the cells C6 to C36 from Sheet "MJ - Days" and paste it in C6 to C36 in Sheet "MJ - Swings".

Once you do that the values will correctly populate.

See sample attached.

Is this what you wanted?

Sid
OT-Signup-for-Supervisors--May-2.xlsx
0
 
SiddharthRoutCommented:
poucedeleon: I am not sure which text are you referring to but did you try the file that I posted above? It works.

Sid
0
 
poucedeleonAuthor Commented:
Found the problem on my own
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.