View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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))