View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default 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