need help on Microsoft Excel
 

Can you guys help me on writing Excel formulas.

1) Is there a formula that will compare a benchmark number with that of a variable, with the result choosing the higher of either one. However, if the variable is lower than the benchmark number, it will pick the benchmark.


For example, 200 is my benchmark:

200 compared to 250, the Excel will pick 250


200 compared to 150, the Excel will pick 200


2) Is there a formula that will round up a number up even if it has several decimals .


For example, 88.000001 will be rounded up to 89


Your help is greatly appreciated.

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

1) Paco is right

2) =CEILING(number, fractional digits)

Blue,

I think it is a semicolon ( ; ) not a comma ( , ) separating the two arguments of the function.

Since Jeff wants an integer number, the function would read:

=ceiling(number;0)

Paco,

Comma works for me...might be a regional setting in Excel, since some regions use the comma as the decimal (instead of period "." like in the US). I figured "fractional digits" would be self-explanatory. :D

Blue,

Damn, I thought I knew everything about Excel :D

What about the "max" function. I wrote it with semicolon, do you have to change the semicolon for a comma in US versions or do any of both symbols work?

And, yes, we use comma as the decimal.

PS I envy both your WRX and your VFR. I almoust bought one of each in the past (ended up with an Audi TT and a Suzuki GSE500 instead, but the wife is happier)

Paco,

No worries, my business card reads:

(My Name)
Sr. Software Engineer
Certified PowerPoint Engineer
SQL Grunt
Excel Monkey

:D

The USA-regionalized Excel doesn't like the semicolon at all in function calls. Can't say that I've ever used it in Excel...anywhere...even VBA.

I guess that makes up for all the C/C++. :)

The WRX is great but has created serious boost addiction. Very dangerous. :eek:

The VFR is fun but I'm already looking for more power...or more character. It's just to keep me occupied until the perfect Ducati or Aprilia crosses my path.

I just opened and tried using a semi-colon and it didn't work in the US version of Excel. You have to use a comma.

I never knew about the CEILING function - I use ROUNDUP (or ROUNDDOWN, or ROUND). The CEILING one will have its day for me.. thanks Blue.