L
Link
IF I HAVE JANUARY TO DECEMBER IN CELL ACROSS FROM A3:L3 WITH DIFFERENT
NUMBERS UNDER EACH MONTH. THESE NUMBERS ARE BASE ON RESULT FROM FORMULA =
SUM (FROM DIFFERENT CELLS)
UNDER THE MONTH OF MARCH ALTHOUGH THE SUM IS MORE 1(ONE) WANT A FORMULA TO
OVERRIDE SO IT CAN BE EQUAL TO 1 OR LESS.
IN CELL A1 I HAVE MARCH, 2006 AND WANT TO USE CELL A1 AS REFERENCE TO DO
THE OVERRIDE.
NUMBERS UNDER EACH MONTH. THESE NUMBERS ARE BASE ON RESULT FROM FORMULA =
SUM (FROM DIFFERENT CELLS)
UNDER THE MONTH OF MARCH ALTHOUGH THE SUM IS MORE 1(ONE) WANT A FORMULA TO
OVERRIDE SO IT CAN BE EQUAL TO 1 OR LESS.
IN CELL A1 I HAVE MARCH, 2006 AND WANT TO USE CELL A1 AS REFERENCE TO DO
THE OVERRIDE.