[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-users
Subject:    Re: [users] more calc help
From:       Ain Vagula <ain () riiska ! ee>
Date:       2003-09-23 15:09:41
Message-ID: 200309231809.41856.ain () riiska ! ee
[Download RAW message or body]

dB Masters:

> 2- I can't get the IF() to work. I have credit and
> debit columns for buys and sells. and I am trying to
> make them something like:
>
> IF(D4="Buy";=E4 * F4 + G4 + H4;=0) SO if it's a buy it
> adds it all up and puts it in the debit
> column...otherwise it would do the colcs and put the
> totals in the credit column.
>

right syntax is =if(condition;then;else), without = signs before arguments of 
course.

> and a final question, can I make a column a drop down
> select box? So it only can be Buy or Sell in the
> options?

data - autofilter?



ain


[prev in list] [next in list] [prev in thread] [next in thread]