Excel Formula ...

Soldato
Joined
4 Nov 2006
Posts
2,738
Location
Yorkshire
I have a Excel table that has 4 columns headings

Code:
FULLNAME   /   FORENAME   /   SURNAME   /  KNOWN AS

And then sample data will be things like ...

Code:
JOSEPH BLOGGS   /    JOSEPH    /   BLOGGS   /   JOE

FULLNAME is a concatenation of FORNAMESURNAME however, i'd like to change this to be KNOWNASSURNAME but not everyone in the list will have a "known" as name, only those that are called things like Timothy but like to be called Tim

So what I need is a formula that basically says, if there is a a value in KNOWNAS, then use that, but if not, then egnore it and leave it as FORENAME

Any ideas?

Thanks
 
Soldato
Joined
23 Aug 2005
Posts
3,953
Location
Beds
Try an IF ELSE statement, something like

Code:
If cell.value <> Empty Or cell.Value = 0 Then cell.Value
 
Top Bottom