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

problem with formula

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


Joined: 22 Jan 2008
Posts: 8

PostPosted: Tue Jan 22, 2008 10:06 am    Post subject: problem with formula Reply with quote

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)
return to me error 502

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
Back to top
View user's profile Send private message
keme
Moderator
Moderator


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

PostPosted: Tue Jan 22, 2008 10:17 am    Post subject: Reply with quote

Did you read the answer you got in the Math forum?
Back to top
View user's profile Send private message
Corfy
Moderator
Moderator


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

PostPosted: Tue Jan 22, 2008 10:44 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Jan 22, 2008 10:48 am    Post subject: Reply with quote

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.
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