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