Hi, i have a scenario in which im trying to make a formula using other tables.

=(Scores!B3)-('Submit Times'!B3-B$29*0.05*Scores!B$29)
This shows what i did. I came out with a huge negative number... but i'm not supposed to get that, i'm supposed to get 10.55.

(student's score ) - (days late * 0.05 * possible points)
This is similar to what i wrote above, but i don't know how i got a huge negative number. Plz help!

The values for B3 from Scores work sheet is 8, values of B3 from Submit Time worksheet is 02/09/05, values of B$29 from Submit Time worksheet is 02/14/05, and values of B$29 from Scores worksheet is 10.

Message me if you have AIM or yahoo. MY AIM is ladeda063610. MY yahoo is ladeda16. Please message/im me because i think you understand better if you message me

=(Scores!B3) --(TEXT('Submit Times'!B3, "DD")- TEXT('Submit Times'!B29, "DD")* 0.05* Scores!B$29)

hi ladeda,
theres a couple of things wrong with this
1. the reason you are getting the huge negative is because you are subtracting dates (its negative because the dates are behind that minus sign)

2. if the score was 8
and the max score was only 10
and the guy turned it in late...then how is he getting 10.55? thats higher then the max

anyway
put this formula together in your sheet:

=(Scores!B3)-(NETWORKDAYS
('Submit Times'!B3,'Submit Times'!B$29)*0.05*Scores!B$29)

i get 6
the networkdays formula counts 4 day late (thats 10th, 11th, 12th, and 13th)
4*.05*10=2
so subtract 2 from 8

edit-
David, good catch on the worksheet name issue