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

"George" wrote:

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.
--
611211