Thanks everyone for the ideas.

I finally got the formula to work.
I was placing the () in the wrong place.

the final formula that worked in instance was:
*=IF(L20,SUM(L2-G2),0)* and in the cells that I have formatted as
Accounting, if l2 =$0.00 M2 comes back with $ -. If l2 is 0, then it
will come back as $100.00 (Gain) and ($100.00), which is what I was
looking for.

I knew I was close, but... just looking at it too long...or it could be
that I was brain dead..
Ron


--
Ron Woolley
------------------------------------------------------------------------
Ron Woolley's Profile: http://www.excelforum.com/member.php...o&userid=30904
View this thread: http://www.excelforum.com/showthread...hreadid=505977