Help

[Tim T via OfficeKB.com]

Below is what I have on a spreadsheet. I need sum up the P&L values for each
period (month) by counterparty. If the sum is positive it is an AR, If
negative an AP. Anyone know a quick way to do this?






Period Counterpart P/L AR AP
Jul-05 Coke 5000
Jul-05 Coke 10000

 

[Mike]

In D2
=IF(C2>0,"AR",)
In E2
=IF(C2>0,"AP",)
Then highlight D2 to E3 and hit control d