Check how to add dr and cr sign in excel sheet



(Guest)

Download and learn how to make your own bank statement format in Excel Sheet with "Dr" and "Cr" sign

Hello friends, yesterday night i make some tricks in Excel sheet, fortunately i found an idea and make a Bank Statement sheet in Excel.

I am Share this Sheet and also share how you make this your own.

Click here to Download Bank statement format in Excel

Learn How to make your own

 

Read the Rest Story, Click here

1 Like

(Guest)

thanx for the same.

avater

HS Negi (Senior Executive- F&A)     13 February 2012

HS Negi
Senior Executive- F&A 
 39 likes  590 points

View Profile | My Other Post

Really informative.

avater

Kamaraj Mani. N (Chartered Accountant - Product Manager)     23 February 2012

Kamaraj Mani. N
Chartered Accountant - Product Manager 
 10 likes  553 points

View Profile | My Other Post

I try to explain the custom format string. kindly refer this link

I hope this will explain you why we need to use format symbols in custom format string. (this covers adding debit/credit text with the values entered in a cell)

Dastagir Bhura (Programmer)     08 May 2012

Dastagir Bhura
Programmer 
 21 points

View Profile | My Other Post

Good thinking it will look better if you add "IF" condition

=IF(G6-I6=0," ",+K5+G6-I6)

in balance colume it will show blank if amount is not enter in G or I Colume

 


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  



Popular Discussion


view more »