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