Salamullah
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 221
I have many account numbers in column A but if account 501000 & 511000 comes then text required in Cell B1 is "Good" else blank.
I only know formula as follows, how to add 511000 also in the formula ?
=If($A$1:$A$1000="501000","Good","")
I only know formula as follows, how to add 511000 also in the formula ?
=If($A$1:$A$1000="501000","Good","")