|
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.
__________________
1989 911 3.2
1990 964 3.6
|