Dimple has attended:
Excel Intermediate course
If function when you want to use text not a number
hi there,
i am using a spreadsheet whereby I want to use Column D to to flag anyone who is listed as something (text) in Column A.
I need an IF function in column D, so that I am saying that:
IF (for example) the person's name is Bob, then I want column D to say Yes, otherwise it can say No.
how do I do this?
RE: If function when you want to use text not a number
Hi Dimple
Thank you for using the forum to ask a question.
You require a function that will check if the cell in Column A is Text which is =ISTEXT(A1)
This will test if it is TEXT and return a TRUE or FALSE
The formula in Column D would be
=IF(ISTEXT(A1),"Yes","No")
I hope that helps
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: If function when you want to use text not a number
no, that is not what I wanted. sorry if I was unclear.
ok imagine this (btw, easier if I could upload an example):
column A and column b contain first and second name. then column C asks whether they are clinical/non clinical. column D then asks what sub-set clinical they are. some people will be blank as they are non clinical, this is fine. some will say 'gp', 'nurse' etc. I want to create a further column of 'public health' (i.e. colun E), which essentially would say 'yes' or 'no' if someone has answered GP or Practice manager in column D. i.e. we have identified that they are clinical, we identify that they are a subset and now we want to further categorise them.
so I want to put an IF forumula in column E, to say; if in column D they have said GP, then column E for whether they count as public health should say ;yes', otherwise, 'no'
RE: If function when you want to use text not a number
Hi Dimple
Thank you for providing more detail.
The IF formula would be
=IF(D2="GP","Yes","No")
If you needed to include GP & Practice Managers to say Yes
=IF(D2="GP","Yes",IF(D2="Practice Manager","Yes","No"))
I've attached an example
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Dimple 10-11-17.xlsx
