| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 If function
I have a spread sheet in excel 2003 that has formular in it that add various
cell values to gether and when i use the If function to test the cells i keep getting wrong results =IF(AC30,1,0) every result = 1 even though the value in the cell is zero AC3 contains =IF((C3+E3+G3+I3+K3+M3+O3+Q3+S3+U3+W3+Y3)0,(C3+E3 +G3+I3+K3+M3+O3+Q3+S3+U3+W3+Y3)/AT3,"") can anyone tell me what i am doing wrong as i am new to excel and used to lotus 123 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
| excel 2003 right-click function not working | Excel Worksheet Functions | |||
| Excel 2003, Insert Function, create full name & descriptions | Excel Worksheet Functions | |||
| Excel 2003: can I insert a "last edited" date function? | Excel Worksheet Functions | |||
| WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003??? | Excel Worksheet Functions | |||
Threaded Mode
