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.
|