Conditional formula

[Thafir021]

Hi,
Is there a function like OR where I could have multiple formulas to be nested as options depending on what A3 would be? So instead of only the true or false OR provides, I'd like it to say IF A3= say 10 different items I type out, then it would require 1 of the 10 different formulas to be applied. I hope this makes sense, fairly new to excel and learning as I go along!

 

[RobP]

So you want to apply 1 of 10 different formulas to the same cell ?

Not sure to catch quite what you mean - maybe an example would be useful ?

cheers

Rob

 

[myall_blues]

You can nest IF statements, although if you have more than about 3 nest levels then I'd suggest taking other approaches.
Since you are using 365 you can use the IFS statement, which has the general syntax

[I]=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)[/I]

'Value if true' can be another formula, so for example in your case:

=IFS(A3=1, SUM(3,5),A3=2,AVERAGE(3,5))

See the Microsoft support page for further details.

 

[Thafir021]

So you want to apply 1 of 10 different formulas to the same cell ?

Not sure to catch quite what you mean - maybe an example would be useful ?

cheers

Rob

Hi Rob,

Thanks for the response. I'll give an example of what I'm attempting below:

I want to work out worker bank/public holidays for different regions (spain, engalnd, ghana, etc.). I have 10 regions bank holiday dates, I have the list of workers and I have a holiday description column stating which regional holiday applies to each worker ( E.g., RobP - UK Bank Holiday). The regional holiday dates are on a sheet of their own.

Does this help?

 

[RobP]

so as an example (to try and understand what you have) .. its something like this ? (where 1 = bank holiday applies to that country, 0 = does not apply.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Worker	Holiday Description				Holiday dates	UK	Spain	France	Germany	Ghana	etc
2	Jim	UK				01/01/2024	1	1
3	Fred	Spain				29/03/2024	1	1
4	Ian	Germany				01/04/2024	1	1
5	Tim	Ghana				01/05/2024	0	1
6						06/05/2024	1	0
7						27/05/2024	1	1
8						26/08/2024	1	1
9						25/12/2024	1	1
10						26/12/2024	1	1
11
12
Sheet1

does it make sense ?

In this case, I'm not sure what you are now trying to calculate ?

Rob