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