Line to reflect a Dash if no value

BB - May 11, 2010 at 08:27 AM
 BB - May 11, 2010 at 09:16 AM
I am designing a check book registry, and I want the total column to reflect a - if there is no value from the formula. I had it this way in the past, but somehow can not get it to be that way again. My current formula is =G1-F2+D2, so I think it would involve the "IF" funtion, but I need some help.

Please and Thanks!


2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 11, 2010 at 08:56 AM
I think if you format the cell and choose "Accounting", it will do that for you
I figured it out!! Thanks for the help though it would be =IF(SUM(G1-F2+D2)=G1,0,SUM(G1-F2+D2)) ... just in case anyone needs help with it in the future.