IT Help Desk > Use of PC

Microsoft Excel: Learning Tutorial

<< < (7/12) > >>

faham:

--- Quote from: ashiqbest012 on November 23, 2010, 03:00:08 PM ---(N.B: "IF" function can't be used more than 8 times.)
So, I have created the number of 2 Grade column and the number of 2 GPA column.

--- End quote ---

"IF" function can't support more than 8 times. It's a problem.
Showing in 2 column and linked 2 column is a great idea :)

ashiqbest012:
 ;D ;D ;D ;D ;D ;D ;D ;D


--- Quote from: faham on November 23, 2010, 08:14:38 PM ---"IF" function can't support more than 8 times. It's a problem.
Showing in 2 column and linked 2 column is a great idea :)

--- End quote ---

haha...vhai, khaiya daiya amar kam nai. tai notun notun idea bar kori....

Thank you Mr.FAHAM bhai

ashiqbest012:
Faham bhai, I have generated a new idea after reading your comment. Than you will see the final grade and gpa in one column. Wait for a moment, , I will share with you after preparing.

ashiqbest012:

ashiqbest012:
Formulas
F.Grade
=IF(P17="F","F",IF(P17="D","D",O17))

F.Gpa
=IF(S17="0","0",IF(S17="2","2",R17))

Navigation

[0] Message Index

[#] Next page

[*] Previous page