Need Excel formula "IF" help ASAP!!

By welcome07 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums