Question Locked

Need Excel formula "IF" help ASAP!!

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.