• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

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
0
poucedeleon
Asked:
poucedeleon
  • 2
  • 2
1 Solution
 
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
 
poucedeleonAuthor Commented:
Found the problem to be the type of data.It was entered as text instead of a number.
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now