• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional serial no as ansewered

INCOMETAX111

New Member
I have 4 no of cells where A1=a
Now I require a formula in cell b1 = if(or(A1=a,a1=b,a1=c),or(1,2,3,4),0)
Means when cell A1=a then b1=1 as b=2,c=3
Can any one help me ?
 
Back
Top