Display total in more than one cell...

  • Thread starter Thread starter mysweet
  • Start date Start date
M

mysweet

Hi, I'm new here :)

I'm working on a Fringe Benefits sheet and having some problem entering
formula calculations.

In the Word document I was given, there are columns called "In Debt By
-" and "In Credit By +" (see attached image). I want to transfer this
information into Excel.

The problem I have is (and don't know a formula for) if the running
total value is positive, it should only be displayed in the "In Credit
By +" column, and if the running total value is a negative value, it
should only be displayed in the "In Debit By -".

Does anyone have a formula I can use for this calculation? Thank you
very much :)

'[image: http://img91.imageshack.us/img91/45/fringe14ka.png]'
(http://imageshack.us)
 
Amount in A1

B1: =IF(A1<0,A1,"")
C1: =IF(A1>=0,A1,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thanks, but I'm not sure how to apply that to my Excel sheet (the
formula you gave me works in a blank one though).

Maybe if I attach the sheet I'm working on (with data copied from Word
in it; not calculated by Excel) you could input the formula in the
correct place (just one row would be good so I understand).

If you can help me, thank you :)


+-------------------------------------------------------------------+
|Filename: Sheet1_X.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4278 |
+-------------------------------------------------------------------+
 
Try this,

in E7: =IF(SUM($E6:$F6)+$C7-$D7<0,SUM($E6:$F6)+$C7-$D7,"")
in F7: =IF(SUM($E6:$F6)+$C7-$D7>=0,SUM($E6:$F6)+$C7-$D7,"")

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top