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