Need Excel formula “IF” help ASAP!!

I have 6 parameter with rating like if SUP,MOD,3RD,CST ,FUT,NS

rating is as follows:
SUP = 1,MOD = 2,3RD = 0.5 ,CST=5 ,FUT= 1,NS= 0

now if there is value ‘x’ in ‘SUP’ column and other cell are blank then excel should retuen the rating value ie.1, similar way if there is value “x” in ‘3rd’column and other call bank , excel should return the rating value i.e. 0.5