Forum Discussion

Copper Contributor

Mar 27, 2017

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...

Mar 28, 2017

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")

SergeiBaklan

Diamond Contributor

Mar 28, 2017

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")

Mark Hayman

Copper Contributor

Mar 28, 2017

Great... this solves my problem !

thank you.