ROUNDING
 

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

ROUNDING
 

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

ROUNDING
 

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


"George" wrote in message
...
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

ROUNDING
 

Hi George

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

Regards
Andrew Bourke


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.