Question

Locked

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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums