ROUNDING

[Guest]

I'M USING AN IF FORMULA TO COMPARE THE LESSER OF 2 CELLS =MIN(L7:L9). I
WANT TO ROUND THIS COMPARISON TO WHOLE PERCENT. I HAVE TRIED TO SET THE CELL
TO ZERO DECIMALS, BUT THE CALCULATION OF THE NEXT FORMULA STILL RECOGNIZES IT
AS THOUGH THERE ARE 2 DECIMAL PLACES. EXAMPLE L7 IS 29.333% AND L9 IS
58.33%. THATS WHERE MY C13 HAS A FORMULA =MIN(L7:L9). EVEN IF C13 IS WHOLE
NUMBER IT IS CALCULATING AT 29.333% TIMES THE NUMBER IN THE ADDITIONAL CELL.
ANY SUGGESTIONS? THANKS IN ADVANCE.

 

[Guest]

George-

Under the Tools menu, select Options/Calculations/Workbook Options /
Precision as Displayed.

This will force Excel to restate the values in the worksheet to the numbers
that are displayed and use those amount for the calculation. Be careful.
Selecting this option will change the numbers in your workbook and precision
will be lost.

Stan Shoemaker
Palo Alto, CA

 

[TOM]

Look up the CEILING() ROUND() and FLOOR() functions (using help).

 

[Ajtb]

Hi George

Try this in cell C13 :
=ROUND(MIN(L7:L9)*100,0)/100

Regards
Andrew Bourke