|
1. =max(number;banchmark)
Where number and benchmark are references to cells where you have these numbers.
2. In my Spanish version of Excel the function is:
=redondear.mas(number)
I guess there is a similar function in your English version, try:
= round.up(number) or look for a similar funtion in the function library under "mathemathics and trigonometry" (you can access the function library pressing the "fx" button in the toolbar)
Or you can use =round(number+0.5)
This will add 0.5 to the number before rounding, ensuring that it will be rounded up.
Good luck
Last edited by Paco Anton; 11-03-2003 at 06:45 AM..
|