I need some help in generating a formula that will insert a result in a
gradesheet based on the result in a cell on another worksheet in the same
workbook.

I have a gradebook which stores raw grades in cells D7 and F7. This result
is in a worksheet called GradeBook 15%, 65% & 20%. I have another worksheet
called GradeBook 10%, 80% & 10% that stores the raw grades in cells in D7 and
F7. The results of these cells needs to be copied to an upload file in excel
that will convert these raw figures to a weighted grade. I can do the
conversion but I cant get the data to come across to the upload sheet. I have
succeeded in getting one but the other will not come across. Is theer some
way of getting the upload sheet to recognise that if there is no data in one
sheet, but data in the other, to copy the other data across and calculate it.

I have the following formula in cells D7 and E7 in the upload file :
"='Gradebook - 15%, 65% & 20%'!D7*D6/100"

I need to know if it is possible to expand this to recognise the other
worksheet and insert the data from the other sheet if the existing one has no
data. Only one or the other will actually have data at the one time.

Thanks for your help.

Brian