[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
sstoyanov
General User

Joined: 22 Jan 2008
Posts: 8

Posted: Tue Jan 22, 2008 10:06 am    Post subject: problem with formula

hello... recently I try to use Open Office in my work, but I cant understand what exactly is wrong with theese parameters... in Microsoft Excell (any version) everything work just perfect... but in Open Office:

 Code: =COUNTIF(INDIRECT(B20&"!a3:a800");K23)

I have the same error with

 Code: =IF(C23;SUMIF(INDIRECT(B20&"!B3:B1000");C23;INDIRECT(B20&"!T3:T1000"));"₮")

and so on...

 Code: =tcena+IF(L15;L15*0,012;0)+IF(L16;L16*0,0024;0)+IF(L17;1,2;0)+IF(L18;0,6;0)+IF(L19;L19*0,0036;0)
returns to me #N/A ... sorry for my (probably easy and stupid) question, but nothing in my searches with google helps to figure out that problem.

Thanks you - Stanimir Stoyanov
keme
Moderator

Joined: 30 Aug 2004
Posts: 2909
Location: Egersund, Norway

 Posted: Tue Jan 22, 2008 10:17 am    Post subject: Did you read the answer you got in the Math forum?
Corfy
Moderator

Joined: 14 Jun 2005
Posts: 1117
Location: Near Indianapolis, IN, USA

 Posted: Tue Jan 22, 2008 10:44 am    Post subject: OK, this is pretty much off topic, but I want to thank you, sstoyanov. I am hardly an expert at spreadsheets, although I am learning. But I was looking at your second formula and thinking that there was an invalid "if" argument. You seemed to have "if C23, then... " with no apparent conditions for C23. Before making an idiot of myself by suggesting that was your problem, I pulled up Calc and tried it. Basically, if anything is in C23, then it used the "then", and if C23 was empty, it used the "else". I didn't know it did that. I can really clean up some of my spreadsheet formulas. Unfortunately, it seems to see empty and "0" as the same thing, which will limit some of its usefulness to me, but this is great. I know this doesn't help you at all, but thanks._________________Laugh at life or life will laugh at you.
David
Super User

Joined: 24 Oct 2003
Posts: 5668

 Posted: Tue Jan 22, 2008 10:48 am    Post subject: Also, why post it there as a [poll] option when none is required? Please read up on the syntax used by Calc, vs that you are presently using. They are not the same, but are different as languages are different, or local idioms in the same language are different. You will need to learn the language and structure. note especially the use of the semi-colon instead of the comma. If you could say what it is you are trying to accomplish and within context, you could expect more help on that. For example, =tcena+IF(L15;L15*0,012;0)+ etc makes no sense to me outside of that context. David.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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