2 Replies Latest reply: Sep 21, 2011 5:44 AM by Donald Posthuma RSS

    Using applymap as a conditional in IF statement

    Donald Posthuma

      Hi everybody,

       

      I want to use a construction where the execution within an IF statement is determined wheter an APPLYMAP succeeds in finding a value. My script would look like this:

       

      IF(Applymap(a,b), x=1, x=2)

       

      However the applymap will always give a value. Either the value which is found using the APPLYMAP or the the value b. Is there a way to use the APPLYMAP statement as a boolean?

       

      Thanks!