I have this formula in a cell (=IF(SUM(BJ94:BJ96)<BJ95,BJ95,BJ96+BJ95+BJ94).
this formula does not function correctly in all conditions. In certain
conditions it needs to run like this
(=IF(SUM(BJ94:BJ96)<BJ95,BJ95,BJ96+BJ95). and in another condition it need
to be this (=IF(SUM(BJ94:BJ96)<BJ95,BJ95,BJ96+BJ95)-(bf109-bf113)

What I need to do is set a condition something like this =if(Bf113<bf109)
choose a say this formula
(=IF(SUM(BJ94:BJ96)<BJ95,BJ95,BJ96+BJ95)-(bf109-bf113)

So the final question I have is! Is it possible to set say three conditions
and have a formula and it choose a separate formula per each condition. in a
single cell.