Forum Discussion

Mark Hayman's avatar
Mark Hayman
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...
Formulas & Functions
tips and tricks
  • SergeiBaklan's avatar
    SergeiBaklan
    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's avatar
Mark Hayman
Copper Contributor
Mar 28, 2017

Thanks

 

The Switch function could help.... however does the Switch formula allow for IF features?

 

Please see attachment, which shares more information.

The objective is to display a result based on the inputs of CLASS and expenditure($$) based against the budget.

 

Resources