Sophie has attended:
TD Intermediate Plus course
If functions
Hello there
I would like to create a formula that populates based on multiple IF functions, pulling different results depending on which IF is true.
For example, IF its X then put A, if it's Y then put B, if it's Z then put C (for up to 25+ IF variables)
Firstly, is this possible? Secondly, how might I go about it?
Thanks in advance!
RE: if functions
Hi Sophie,
Thank you for the forum question.
You can use the IFS function.
=ifs(a1=“x”, “a”,a1=“y”,”b”,a1=“z”,”c”……)
The IFS function can work with up to 128 tests.
regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
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 functions
Thanks Jens
Is it possible to pull that information from another sheet? For example
If its X then put 'sheet1 cell A1', if it's Y then put 'sheet 1 cell A2', and so on?
RE: if functions
Hi Sophie,
Yes
Type =ifs(a1=“x”,
and then navigate to the sheet and click on the cell you want to reference.
or type it.
=ifs(a1=“x”, 'sheet Name'!b4,a1=“y”,'sheet Name'!b4,a1=“z”,'sheet Name'!b4……)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
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
