You're correct. After importing csv file to OO I then add formulae.
Here's a couple of straightforward IF stmnts.
#if(e5>10,e5+g4,"none")#
#if(e5,g4-e5,g4+f5)#
Note: I don't place = or + before the IF. Seems to work okay.
e5 g5 f4 formatted to 'fixed'.
Used above for my checkbook register.
oops: should be e5 g4 f5
Have you checked out /knoppix/usr/local/share/siag/siag ? Especially 'functions.scm'That's what I tried, and it doesn't work; instead it selects the first choice no matter what. I tried your example; same error.
Thus:
if(5>10, 9,0) produces 9. I'm surprised it works on your copy, since I'm using ver 3.5.7Hi jpeters,
The second example I gave was for my cb register it has been working.
if(debit,bal-debit,bal+credit)
The > or < does not seem to work with the IF stmnt. Must be another way to do it. Have been searching the Web but no success so far.
Will let you know if I find the solution.
Edit: So far I determined SIAG IF statement with < or > works as " if ...then" only.
Have been used to: "if..then..otherwise"
edit: My mistake, > or < still not working with IF. Darn it.
edit: 3/26 130pm
You're right. So far SIAG is doing the basics for me. That's all I need most of the time. Thanks for all the info.
Quote (JohnJS @ Mar. 26 2007,10:35)
My mistake, > or < still not working with IF. Darn it.
Actually, it isn't working with anything. "if(23==45,1,0)" produces "1"
No sense beating a dead horse; Schemes don't work either, meaning a lot of the functions have been stripped out; great if you need a basic chart, but for all else, oo.There's always Gnumeric - see the UNC repositry. It now only needs GTK loaded to work & is more powerful than Siag, yet not as slow to load as OO.Next Page...
original here.