[X4U] Excel problem
    Paul Moortgat 
    paul.moortgat at pandora.be
       
    Sun Dec 30 14:56:10 PST 2012
    
    
  
In colon 2 is the number 2
In colon 3 is the number 2
In colon 8 there is the text OK
In colon 9 that when 8 contains OK I need to add the values from colon 2 and 3 which should give 4.
If colon 8 is not OK the cell in 9 is 0 (zero)
For this I use the formula in colon 9:  =IF(RC[-1]="OK",SUM(RC[-7]:RC[-6]),0) which always gives me an error for OK.
I tried 'OK' and "OK" and a plain OK.  Nothing helps.  I get the message that's there a problem with the OK description in the formula.
What do I wrong?  I use the R1C1 way in version 11.
Paul Moortgat
    
    
More information about the X4U
mailing list