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" <mysweet.22ef8z_1138542302.5728@excelforum-nospam.com> wrote in
message news:mysweet.22ef8z_1138542302.5728@excelforum-nospam.com...
>
> 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
>