My Marksheet

[arif]

Sirs

I have s marksheet in which passing marks are at least 35
Suppose i want to add gracing marks to those students who have got at least 25 marks and then 35 marks for these students should be shown as 35* (as they have got gracing marks) and along with that total marks should also be increased as per addition for making such students pass .

Plz suggest to me what should be done

 

[Lakshmi Narain]

Sirs

I have s marksheet in which passing marks are at least 35
Suppose i want to add gracing marks to those students who have got at least 25 marks and then 35 marks for these students should be shown as 35* (as they have got gracing marks) and along with that total marks should also be increased as per addition for making such students pass .

Plz suggest to me what should be done

Dear Arif,
PFA
If you want to change the mark. Then change in actual marks.

 

[Somendra Misra]

Hi Arif,

It must be a coincidence but same 100% same question is asked on below site by a user name Anmol which I answered some 30 mins back .


http://www.excelforum.com/excel-general/1043314-marksheet-with-gracing-marks.html#post3866680

So I can call this as a cross-post of a question with different user.

Regards,

 

[arif]

Dear Arif,
PFA
If you want to change the mark. Then change in actual marks.

Dear sir

if we have to play with data manually what is excel for

oh

 

[Lakshmi Narain]

Dear sir

if we have to play with data manually what is excel for

oh

Dear Arif,
Have you open my attached file. check the formula i mentioned there.
There i have mentioned Actual Mark and Grace Mark.
In future you want to change or update any marks, you can change in actual mark table. Do you understand what i am trying to say. Please Open and see my attachment.

 

[arif]

Dear Arif,
Have you open my attached file. check the formula i mentioned there.
There i have mentioned Actual Mark and Grace Mark.
In future you want to change or update any marks, you can change in actual mark table. Do you understand what i am trying to say. Please Open and see my attachment.

Ya thanks a lot
i change 35 to 35* by adding two inverted commas around this word
but now it is change to text so its not included in the sum of the total
plz again

 

[Lakshmi Narain]

PFA,

 

[Somendra Misra]

See the file.

Regards,

 

[arif]

PFA,

Ok thanks

Now seems i must be fully satisfied as my problems seems to have been solved

thanks