Creating one formula for use in two different cells

  • Thread starter Thread starter Dutilbug
  • Start date Start date
D

Dutilbug

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-H11>0,+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.
 
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-H11>0,+E11-F11+G11,
IF(E11-F11+G11-H11<0,-(+E11-F11+G11-H11),0)

regards
FSt1
 
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-H11>0,+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.
Click to expand...


You nest another IF inside the false response for the first one.

=IF(E11-F11+G11-H11>0,+E11-F11+G11,IF(E11-F11+G11-H11<0,-(+E11-F11+G11-H11),0))

I exchanged the word "positive" and "negative" for your action to prove
that it works in my test as your actions always yield a positive number.

=IF(E11-F11+G11-H11>0,"Positive",IF(E11-F11+G11-H11<0,"Negative",0))

You should probably refrain from asking for solutions for your school
coursework as you are not really learning anything.

I found the nested IF in the basic help for the IF function.

I almost hope it is wrong so you get busted...
 
Back
Top