ExcelBanter - Can I create a formula with more than the YES/NO option

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I create a formula with more than the YES/NO option (https://www.excelbanter.com/excel-discussion-misc-queries/125788-can-i-create-formula-more-than-yes-no-option.html)

Lor

Can I create a formula with more than the YES/NO option

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

[email protected]

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

pinmaster

Can I create a formula with more than the YES/NO option

Hi,

Maybe something like:

=IF(B5<=Y63,B25,IF(B5<=Y65,B26,B24))

Hope this helps!
Jean-Guy

"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

All times are GMT +1. The time now is 09:59 PM.