formula for finding out the negative numbers

  • Thread starter Thread starter Igneshwara reddy
  • Start date Start date
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.
 
Igneshwara,

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

HTH

brotha lee
 
Assuming no empty cells or text entries in the range.

Try this:

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

Copy down as needed
 
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

HELP! Need to sum columns where credit balances are shown as ###CR 20
How do I create the formula for this calculation? 1
how to build a formula to match numbers in 2 columns with the equ. 1
copy and paste 1
Formula to FIND DUPLICATE DEBIT AND CREDITS 2
Return a value when the number is negative 3
Aging by netting negatives in other age buckets for the customer 3
help with the function 3

Back
Top