Display total in more than one cell...
 

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)


--
mysweet
------------------------------------------------------------------------
mysweet's Profile: http://www.excelforum.com/member.php...o&userid=30943
View this thread: http://www.excelforum.com/showthread...hreadid=506144

Display total in more than one cell...
 

Amount in A1

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mysweet" wrote in
message ...

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)


--
mysweet
------------------------------------------------------------------------
mysweet's Profile:
http://www.excelforum.com/member.php...o&userid=30943
View this thread: http://www.excelforum.com/showthread...hreadid=506144

Display total in more than one cell...
 

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

--
mysweet
------------------------------------------------------------------------
mysweet's Profile: http://www.excelforum.com/member.php...o&userid=30943
View this thread: http://www.excelforum.com/showthread...hreadid=506144

Display total in more than one cell...
 

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)

"mysweet" wrote in
message ...

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

--
mysweet
------------------------------------------------------------------------
mysweet's Profile:
http://www.excelforum.com/member.php...o&userid=30943
View this thread: http://www.excelforum.com/showthread...hreadid=506144

Display total in more than one cell...
 

Thanks Bob YOU are a life-saver, it will make my job so much easier.
Blessings :cool:


--
mysweet
------------------------------------------------------------------------
mysweet's Profile: http://www.excelforum.com/member.php...o&userid=30943
View this thread: http://www.excelforum.com/showthread...hreadid=506144