Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for getting the breakup of net amount
Hi All,
I have a column of positive & Negative values. As given in the Example below ( actual data may run to more than few thousands of rows ). Could some one tell me how to find the values which have exact positive & negative values. ie., from the example below i need to know : - 1 - 100 & -100 are summing to zero. 2 - second 200 & -200 are summing to zero 3 - first -300 & next 300 are zero when summed If you need any clarification please post back. Example Column A 100 -100 200 200 -200 -300 300 300 300 500 -500 -500 500 500 -500 1000 -1000 -1000 -1000 -1000 1000 Thanks, Thyagaraj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for getting the breakup of net amount
Hi Thyag,
Paste the below formula to Column B and Column C, and copy till you have data Column B = =IF(LEFT(A3,1)="-",A3,0) Column C = =IF(LEFT(A3,1)<"-",A3,0) "Thyag" wrote: Hi All, I have a column of positive & Negative values. As given in the Example below ( actual data may run to more than few thousands of rows ). Could some one tell me how to find the values which have exact positive & negative values. ie., from the example below i need to know : - 1 - 100 & -100 are summing to zero. 2 - second 200 & -200 are summing to zero 3 - first -300 & next 300 are zero when summed If you need any clarification please post back. Example Column A 100 -100 200 200 -200 -300 300 300 300 500 -500 -500 500 500 -500 1000 -1000 -1000 -1000 -1000 1000 Thanks, Thyagaraj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the formula for returning the amount to amount in words | Excel Discussion (Misc queries) | |||
Range Breakup | Excel Discussion (Misc queries) | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
breakup spreadsheets | Excel Programming | |||
breakup spreadsheets | Excel Programming |