| View previous topic :: View next topic |
| Author |
Message |
turtle
General User
Joined: 05 Jun 2008
Posts: 8
Location: $hell
|
 Posted: Thu Mar 08, 2012 1:48 pm Post subject: IF Statements in tables |
 |
|
Simple question however I have searched around and not seen a similar topic.
I have a table in oowriter that is computing values based on cells:
=<B7>*<C7>
However if the value is zero I get lots of zeros 000
If the value is zero I would prefer a empty cell.
I have attempted to use a if statement as follows:
=IF(<B7>*<C7>=0; ;<B7>*<C7>)
Instead I am getting:
** Expression is faulty **
Thanks in advance |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8983
Location: Lexinton, Kentucky, USA
|
| Posted: Thu Mar 08, 2012 2:42 pm Post subject: |
|
|
IF is not available in a Writer table.
Using Insert > Object > OLE you can insert a Calc item into Writer. |
|
| Back to top |
|
|
turtle
General User
Joined: 05 Jun 2008
Posts: 8
Location: $hell
|
| Posted: Thu Mar 08, 2012 6:33 pm Post subject: |
|
|
Hey thanks for your reply.
I guess Ill live with the zeros.
Was not a big deal. |
|
| Back to top |
|
|
|
