OK, I figured out what I was doing wrong.
I changed the Formula to: =IF(B90,B9+D9+E8,IF(B9<-0.99,B9+E8,E8)+D9)
(See Attached Pic)
All cells seem to contain the correct info now.
Thanks much Peo Sjobom and Celt for all the help. I've been trying to
figure this out for a couple of months now and have been banging my
head on my desk in frustration. Now I can get rid of the Ledger Books
and do it all on the PC. :D
+-------------------------------------------------------------------+
|Filename: Photo5.gif |
|Download:
http://www.excelforum.com/attachment.php?postid=4630 |
+-------------------------------------------------------------------+
--
John_Doe69
------------------------------------------------------------------------
John_Doe69's Profile:
http://www.excelforum.com/member.php...o&userid=33439
View this thread:
http://www.excelforum.com/showthread...hreadid=532524