View Single Post
Paco Anton Paco Anton is offline
Registered
 
Paco Anton's Avatar
 
Join Date: May 2002
Location: Madrid, Spain
Posts: 774
Garage
Send a message via Yahoo to Paco Anton
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
__________________
Paco Anton

83 SC Targa (Euro)

Last edited by Paco Anton; 11-03-2003 at 06:45 AM..
Old 11-03-2003, 06:42 AM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #2 (permalink)