OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

What is maximum number of Nested Ifs in Calc?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
mushtaque_asghar
General User
General User


Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan

PostPosted: Mon Jun 29, 2009 2:04 am    Post subject: What is maximum number of Nested Ifs in Calc? Reply with quote

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
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Jun 29, 2009 2:28 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
mushtaque_asghar
General User
General User


Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan

PostPosted: Mon Jun 29, 2009 2:57 am    Post subject: Re: What is maximum number of Nested Ifs in Calc? Reply with quote

Can you please provide complete list of Lookup Function used in OOo?
_________________
Thanks & Regards,
Mushtaque Asghar
http://www.mushtaq4u.tk
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Jun 29, 2009 3:11 am    Post subject: Reply with quote

Can you please read any good book on Excel or any other spreadsheet application?
You may also choose among some hundreds of topics in this forum.
This is one of the most frequently asked trivial ever.
Scrolling down this forum's current topics: http://www.oooforum.org/forum/viewtopic.phtml?t=85768
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
mushtaque_asghar
General User
General User


Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan

PostPosted: Mon Jun 29, 2009 3:25 am    Post subject: Thanks Reply with quote

Thanks Buddy!
_________________
Thanks & Regards,
Mushtaque Asghar
http://www.mushtaq4u.tk
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Mon Jun 29, 2009 3:28 am    Post subject: Re: What is maximum number of Nested Ifs in Calc? Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group