software

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 quot;In Debt By
-quot; and quot;In Credit By quot; (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 quot;In Credit
By quot; column, and if the running total value is a negative value, it
should only be displayed in the quot;In Debit By -quot;.

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

'[image: img91.imageshack.us/img91/45/fringe14ka.png]'
(imageshack.us)--
mysweet
------------------------------------------------------------------------
mysweet's Profile: www.excelforum.com/member.php...oamp;userid=30943
View this thread: www.excelforum.com/showthread...hreadid=506144Amount in A1

B1: =IF(A1lt;0,A1,quot;quot;)
C1: =IF(A1gt;=0,A1,quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;mysweetquot; gt; wrote in
message ...
gt;
gt; Hi, I'm new here
gt;
gt; I'm working on a Fringe Benefits sheet and having some problem entering
gt; formula calculations.
gt;
gt; In the Word document I was given, there are columns called quot;In Debt By
gt; -quot; and quot;In Credit By quot; (see attached image). I want to transfer this
gt; information into Excel.
gt;
gt; The problem I have is (and don't know a formula for) if the running
gt; total value is positive, it should only be displayed in the quot;In Credit
gt; By quot; column, and if the running total value is a negative value, it
gt; should only be displayed in the quot;In Debit By -quot;.
gt;
gt; Does anyone have a formula I can use for this calculation? Thank you
gt; very much
gt;
gt; '[image: img91.imageshack.us/img91/45/fringe14ka.png]'
gt; (imageshack.us)
gt;
gt;
gt; --
gt; mysweet
gt; ------------------------------------------------------------------------
gt; mysweet's Profile:
www.excelforum.com/member.php...oamp;userid=30943
gt; View this thread: www.excelforum.com/showthread...hreadid=506144
gt;

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: www.excelforum.com/attachment.php?postid=4278 |
-------------------------------------------------------------------

--
mysweet
------------------------------------------------------------------------
mysweet's Profile: www.excelforum.com/member.php...oamp;userid=30943
View this thread: www.excelforum.com/showthread...hreadid=506144Try this,

in E7: =IF(SUM($E6:$F6) $C7-$D7lt;0,SUM($E6:$F6) $C7-$D7,quot;quot;)
in F7: =IF(SUM($E6:$F6) $C7-$D7gt;=0,SUM($E6:$F6) $C7-$D7,quot;quot;)

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;mysweetquot; gt; wrote in
message ...
gt;
gt; Thanks, but I'm not sure how to apply that to my Excel sheet (the
gt; formula you gave me works in a blank one though).
gt;
gt; Maybe if I attach the sheet I'm working on (with data copied from Word
gt; in it; not calculated by Excel) you could input the formula in the
gt; correct place (just one row would be good so I understand).
gt;
gt; If you can help me, thank you
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Sheet1_X.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4278 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; mysweet
gt; ------------------------------------------------------------------------
gt; mysweet's Profile:
www.excelforum.com/member.php...oamp;userid=30943
gt; View this thread: www.excelforum.com/showthread...hreadid=506144
gt;

Thanks Bob YOU are a life-saver, it will make my job so much easier.
Blessings --
mysweet
------------------------------------------------------------------------
mysweet's Profile: www.excelforum.com/member.php...oamp;userid=30943
View this thread: www.excelforum.com/showthread...hreadid=506144