I want the result of formula resyricted upto 2 decimals
 

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

I want the result of formula resyricted upto 2 decimals
 

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(A20.8,"Student shows Distinction!","")

HTH,
Bernie
MS Excel MVP


"sbkshatriya" wrote in message
...
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