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.

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.