| View previous topic :: View next topic |
| Author |
Message |
mushtaque_asghar
General User
Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan
|
 Posted: Mon Jun 29, 2009 2:04 am Post subject: What is maximum number of Nested Ifs in Calc? |
 |
|
Dear,
I am using a sheet that uses multiple conditions. As for as my theoretical concepts are concerned, calc can support upto 127 times of Nested Ifs. But unfortunately it works upto 7 times maximum.
Kindly provide support and exact information regarding this matter.
_________________
Thanks & Regards,
Mushtaque Asghar
http://www.mushtaq4u.tk |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Jun 29, 2009 2:28 am Post subject: |
|
|
Seven used to be the limit in MS EXcel.
Using lookups you can do the same as with 65536 nested IFs
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
mushtaque_asghar
General User
Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan
|
| Posted: Mon Jun 29, 2009 2:57 am Post subject: Re: What is maximum number of Nested Ifs in Calc? |
|
|
Can you please provide complete list of Lookup Function used in OOo?
_________________
Thanks & Regards,
Mushtaque Asghar
http://www.mushtaq4u.tk |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
mushtaque_asghar
General User
Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan
|
| Posted: Mon Jun 29, 2009 3:25 am Post subject: Thanks |
|
|
Thanks Buddy!
_________________
Thanks & Regards,
Mushtaque Asghar
http://www.mushtaq4u.tk |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Mon Jun 29, 2009 3:28 am Post subject: Re: What is maximum number of Nested Ifs in Calc? |
|
|
| mushtaque_asghar wrote: | | Can you please provide complete list of Lookup Function used in OOo? |
Certainly. Please read the Help File. Also, there are manuals available for download if you would look through the OpenOffice website for the reference. Also, you might visit a used-book store for a very cheap copy of any book on the spreadsheet [any version.] In fact, you would learn much more on that journey, as did we.
David. |
|
| Back to top |
|
|
|
