formula for finding out the negative numbers

Posted to microsoft.public.excel.worksheet.functions

Igneshwara reddy[_2_] Igneshwara reddy[_2_] is offline

external usenet poster

Posts: 68

formula for finding out the negative numbers

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
finding maximum, minimum in a range consists both Positive and Negative numbers	Praveen	Excel Worksheet Functions	3	May 4th 23 07:45 PM
Negative numbers in resulting formula	Molly	Excel Worksheet Functions	2	April 3rd 08 06:47 AM
Negative numbers in an IF formula	TammyS	Excel Worksheet Functions	18	July 20th 06 09:24 PM
Negative numbers in easy formula getting me down...	jennieoh	Excel Discussion (Misc queries)	3	June 9th 06 05:04 PM
Excel Formula - Add column of numbers but ignore negative numbers	view for Distribution List members	Excel Worksheet Functions	1	April 7th 06 03:13 AM

All times are GMT +1. The time now is 06:51 AM.

Menu

About Us