LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Myrna Larson
 
Posts: n/a
Default

Also check out the CHOOSE function, which allows for 29 or 30 choices, but the
logical test used in the beginning must return an integer which determines
which of the choices to return.

On Fri, 25 Mar 2005 05:57:03 -0800, "crunchh"
wrote:

hello I have seen that it is impossible to nest more than 7 if

I tryed to find if there wheere something counter this proble like a switch
case function in other language something like that
swith
case A1<1 do A2=3
case A1<2 do A2=8
case A1<4 do A2=28
...


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"