problem with formula

sstoyanov · General User Joined: 22 Jan 2008 Posts: 8

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:

keme · Posted: Tue Jan 22, 2008 10:17 am Post subject:

Did you read the answer you got in the Math forum?

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