I'm looking to make an if statement.
In cell a1 down to a10, i have names.
In cell b2, I'd like to put a formula so that if a certain name between a1:a10 shows up, to put an x in b2, if not, put a number zero.
any help would be appreciated!
I'm looking to make an if statement.
In cell a1 down to a10, i have names.
In cell b2, I'd like to put a formula so that if a certain name between a1:a10 shows up, to put an x in b2, if not, put a number zero.
any help would be appreciated!
I've tried =if(a1:a10,"Mike",x,0) is this right?
=IF(COUNTIF(A1:A10,"Mike")>0,"x",0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks