formula for finding out the negative numbers

I

Igneshwara reddy

Hi,

I have amounts in B column nearly 600 lines, the amounts includes negative
amounts and as well as the positive amounts.

amounts like, 100, -55, 253.65, -4954.34

I need a formula to put in C column, so that any negative amount shows as
Credits and positive amounts shows as Debits.

Please help me out.

Regards,
Igneshwara Reddy.
 
B

Brotha Lee

Igneshwara,

You could apply the following custom number formatting on column B
"Debit" #.##0;"Credit" #.##0

HTH

brotha lee
 
T

T. Valko

Assuming no empty cells or text entries in the range.

Try this:

=IF(B2>=0,"Debit","Credit")

Copy down as needed
 
D

Dylan @ UAFC

are you saying the accounting value is neg.
in the corrisponding cell you like it post
the word "credit" or the word "debit"
what are you trying to achieve here
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to build a formula to match numbers in 2 columns with the equ. 1
Return a value when the number is negative 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
copy and paste 1
Negative numbers in resulting formula 2
Multiple Criteria for worksheet 3
I need a formula to add numbers to the result in same cell. 1
help with the function 3

Top