Creating one formula for use in two different cells

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

FSt1

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

ItsASecretDummy

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.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top