need help on Microsoft Excel

[Jeff964]

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.

[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

[BlueSkyJaunte]

1) Paco is right

2) =CEILING(number, fractional digits)

[Paco Anton]

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)

[BlueSkyJaunte]

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.

[Paco Anton]

Blue,

Damn, I thought I knew everything about Excel

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)

[BlueSkyJaunte]

Paco,

No worries, my business card reads:

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



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.

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.

[CamB]

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.