Thread: Multiple If Statement in a UDF

Hiya,

Im trying to build something like this... I think i have the body of it, but i keep getting compliation errors, not surprising though as it's only my second ever UDF Any help would be appreciated.


Function Template (value AS Integer, word AS string) AS string
IF(value = "01") //if cell value = 01
AND IF(word ="test") // if cell value x = 01 and cell value y = test
Template = "yes" //return YES
ELSE
IF(value = "02")
AND IF (word = "test2")
Template = "yes"
//repeat for all posibilities
ELSE
Template = "no" //return NO for all cases not listed
END IF
END FUNCTION


I know its pretty rough, but i think the guts of it is there based on my previous basic programming experience.... little help?


Thanks

Andrew

hi, Andrew, please wrap VB code in code tags (see Forum Rules for details)