Can I create a formula with more than the YES/NO option
Lor wrote:
I need to create a formula that has three options and I don't know if I can
do it in Excel. Is it possible to nest these two statemens in the same cell?
=IF(B5<=Y63,B25,B24)
=IF(B5=Y64,B5<=y65),B26
Yes. But because those conditions are not mutually-exclusive in an
obvious way, it is difficult to suggest a solution. The form of the
solution might look something like this:
=if(and(B5=Y64, B5<=Y65), B26, if(B5<=Y63, B25, B24))
|