TIMESHEET
 

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.

TIMESHEET
 

See how you go with this?

=IF(SUM( FROM DIFFERENT CELLS)1,A1,SUM( FROM DIFFERENT CELLS))



"Link" wrote:

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.