| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
an excel formula for specific conditions
Dear community members,
This is a small data I furnish below: A B C D E Total of B+C+D) 1.Ram 533370 179348 1224123 1936841 2.Sam 700370 189348 924123 1513841 3. 167000 10000 (-)600000 (B2-B1) (C2-C1) (D2-D1) I want a total in E3 cell based on the following conditions: 1. If all columns in row 3 ( B/C/D ) shows plus figures then E2-E1 2. If any of the columns in row 3 (B/C/D) shows minus figures, then the sum of such minus figures (irrespective of whether it is one column, two or three )only to be shown in E3 Is there any formula in excel to do this? I am using excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| an excel formula for specific conditions | Excel Worksheet Functions | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Hybrid Mode
