yes, nested Ifs (or do a vlookup)

do =If(A1=x,3,if(A1=y,2,if(A1=z,0,"None of the above")))

Posted By: Ralf Scrampton, Sep 21, 10:01:03

Reply to Message

Log in


Written & Designed By Ben Graves 1999-2025