If functions

Resolved · Medium Priority · Version 365

Thu 23 Feb 2023, 11:20 Delegate Sophie said...

Sophie has attended:
Excel Intermediate 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!

Thu 23 Feb 2023, 13:25 Trainer Jens said...

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

Thu 23 Feb 2023, 15:29 Delegate Sophie said...

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?

Tue 28 Feb 2023, 20:29 Trainer Jens said...

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

Tue 7 Mar 2023: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips