Visokio website     Downloads     Video tutorials     KnowledgeBase  
If one or more - Visokio Forums
If one or more
  •     davedunckley September 8, 2011 6:39AM
    Hi - I have a several yes no fields, for example:-

    FieldA = 'y'
    FieldB = 'n'
    FieldC = 'y'
    FieldD = 'n'

    What I want to be able to do is have a have an IF statment that will show up Hybrid ='y' if two or more of the above ='y'

    So if a & b = 'y'
    or a & b ='y'
    or b & c = 'y'

    etc. How can I do this, any ideas? Dave
  • 2 Comments
  •     tjbate September 8, 2011 7:33AM
    Dave - This can be done like this:

    IF(
    IF(FieldA='y', 1, 0)+
    IF(FieldB='y', 1, 0)+
    IF(FieldC='y', 1, 0)+
    IF(FieldD='y', 1, 0)
    >= 2, "y", "n")

  •     davedunckley September 8, 2011 8:42AM
    Ah ha!!!

    Thanks Tom, thats just what I needed.

    Works perfect!!!!

    You are the development king!

    Dave
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership