open office writer formula code

[nightmanphill]

how do i find a list of formula coding for writer.

Im making an invoice and in the total colum i want to put $ signs before the total ie: $ 23.00

The code im using now to times the amount of item with the cost of items is =<A2>*<C2>

A=Amount of items
B=Cost of items

I also have 0's where there are no items or total amounts. how can i get rid of them?

you can download the piece im talking about here:
http://rapidshare.com/files/404419798/Bills_master_Invoice.odt.html

cheers phill

[Robert Tucker]

[nightmanphill]

Solved
Im making an invoice and in the total colum i want to put $ signs before the total ie: $ 23.00

Just format the cell to currency. Select the cells in the Total column, right click and select Currency (as Category) and Australian Dollars (as Format).

Not solved
I also have 0's where there are no items or total amounts. how can i get rid of them?

Try selecting the cells and hitting delete a few times. If you were to use Calc you could switch them off at Tools>Options...>OpenOffice.org Calc>View.By hitting delete i also remove the =<A2>*<C2>. I cant get rid of the numerals without also removing the =<A2>*<C2>

=<A2>*<C2> I think that works, doesn't it? Yes it does .thank you, Thought i might have to change to get the right result in the total column

Link to upgraded invoice.
http://rapidshare.com/files/404555645/Bills_master_Invoice.odt.html

[JohnV]

[Robert Tucker]

[nightmanphill]

Solved
Im making an invoice and in the total colum i want to put $ signs before the total ie: $ 23.00

Just format the cell to currency. Select the cells in the Total column, right click and select Currency (as Category) and Australian Dollars (as Format).

Solved
I also have 0's where there are no items or total amounts. how can i get rid of them?

Try the number format:
[$$-C09]#,##0.00;[RED]-[$$-C09]#,##0.00;""

My thanks to Robert Tucker for the solutions.

I think its looking good now and acting like i want it to.
So far with the changes it looks like this:
http://rapidshare.com/files/404589205/Bills_master_Invoice.odt.html



So now i want to add automatic date "changeable"
Also automatic invoice no. "changeale"
be able to select from a list of customers.

So do i need to use another program to work with it. As in if i was using microsoft office i would use access i think.

cheers phill.

[Robert Tucker]