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 problem is the end result - displaying the reommmended Process (A, B or C). If CLASS A has been selected from a separate cell and the cost cell is greater than £10 then display PROCESS AIf CLASS A has been selected from a separate cell and the cost cell is less than £10 then display PROCESS BIf CLASS B has been selected from a separate cell and the cost cell is greater than £10 then display PROCESS BIf CLASS B has been selected from a separate cell and the cost cell is less than £10 then display PROCESS C Example file attached.Is there an easier way other than using the IF function?or maybe what would be the recommend IF function command? Thanks all

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

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 problem is the end result - displaying the reommmended Process (A, B or C).

If CLASS A has been selected from a separate cell and the cost cell is greater than £10 then display PROCESS A
If CLASS A has been selected from a separate cell and the cost cell is less than £10 then display PROCESS B
If CLASS B has been selected from a separate cell and the cost cell is greater than £10 then display PROCESS B
If CLASS B has been selected from a separate cell and the cost cell is less than £10 then display PROCESS C

Example file attached.

Is there an easier way other than using the IF function?

or maybe what would be the recommend IF function command?

Thanks all

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