Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timesheet help | Excel Worksheet Functions | |||
Help with timesheet please | Excel Worksheet Functions | |||
Timesheet | Excel Discussion (Misc queries) | |||
Timesheet help | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions |