I want the result of formula resyricted upto 2 decimals

[Guest]

pl. show ne the proceure to restrict the result yo2 decimals.
show me the formula to find out result of astudent for distinction when
total marks obtained are 80% & above

 

[Bernie Deitrick]

sbkshatriya,

Restrict the result to two decimals:

=ROUND(value,2)

or

=ROUND(OldFormula(.....),2)

And for the second part, if the marks are in cell A2:

=IF(A2>0.8,"Student shows Distinction!","")

HTH,
Bernie
MS Excel MVP