| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating one formula for use in two different cells
I have created a worksheet for accounting in excel. My formulas are for the
adjusted trial balance. My formula for cell I11 is =IF(E11-F11+G11-H110,+E11-F11+G11,0) My formula for cell J11 is =IF(E11-F11+G11-H11<0,-(+E11-F11+G11-H11),0) My instructor is offering bonus points if we can come up with one formula that works for both cells. I am totally stumped and any help is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating one formula for use in two different cells
hi
trick - you can stack if statements. 7 levels in 2003 and earlier. more in 2007 but i'm not sure how many. =IF(E11-F11+G11-H110,+E11-F11+G11, IF(E11-F11+G11-H11<0,-(+E11-F11+G11-H11),0) regards FSt1 "Dutilbug" wrote: I have created a worksheet for accounting in excel. My formulas are for the adjusted trial balance. My formula for cell I11 is =IF(E11-F11+G11-H110,+E11-F11+G11,0) My formula for cell J11 is =IF(E11-F11+G11-H11<0,-(+E11-F11+G11-H11),0) My instructor is offering bonus points if we can come up with one formula that works for both cells. I am totally stumped and any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula to highlight a row of cells | Excel Discussion (Misc queries) | |||
| Creating a formula which would affect multiple cells | Excel Worksheet Functions | |||
| creating a simple formula for a range of cells | Excel Discussion (Misc queries) | |||
| Creating a formula to populate information from multiple cells in another workbook | Excel Worksheet Functions | |||
| When creating a formula how do you select only visible cells | Excel Discussion (Misc queries) | |||
Linear Mode
