Forum Discussion
Solved
Multiple IF function
Hi, I need some help. I'm creating a excel document to help guide user into the correct process to follow. In my example there are 2 classes (A and B) and an example budget limit of £10. My p...
Hi Mark,
It could be something like
=CHOOSE(($E$2="A")*2+($B$4>$B$2)+1, "PROCESS C", "PROCESS B", "PROCESS B", "PROCESS A")
Are you looking for the Switch function:
https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e