View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default balancing cells on criteria

Hello,

I have the following data:

ACC_DAT DIM1 DIM2 DIM3 DIM5 DIM7 JR_NR MONTH REC_AMOUNT BALANCE
010507 9990 15 2000 150 AR30-390 19556 05 90.00
010507 9990 15 2000 190 AR30-390 53339 05 -30.00
010507 9990 15 2000 190 AR30-390 53397 05 -40.00
010507 9990 16 6000 100 AR30-390 53541 05 -10.00
010507 9990 16 6000 190 AR30-395 54072 05 0.01
010507 9990 16 6000 100 AR30-396 56578 05 -50.00
010507 9990 16 6000 190 AR30-396 57076 05 -10.01
010507 9990 16 6000 190 AR30-396 57185 05 60.01

I need a function in column BALANCE that looks if the REC_AMOUNT BALANCES
BASED ON DIM7 OR DIM5 OR JR_NR.

Thanks,