Thread: Creating one formula for use in two different cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dutilbug Dutilbug is offline
external usenet poster
  
Posts: 6
Default 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.

Reply With QuoteReply With Quote