SoftMaker.com

English-Language Support
It is currently Tue Oct 21, 2014 5:42 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Sat Jan 28, 2012 10:41 pm 
Offline

Joined: Fri Feb 05, 2010 8:47 pm
Posts: 8
I am totally and utterly frustrated. Some time ago I created a table. I now need to edit the formulas in some of the cells. I cannot find any way to view the formulas I have in the cells. Since I cannot see the current formulas to edit them, I am trying to just create and insert the correct formula. However each time I meticulously follow the limited help file explanation of creating a formulas, all I get is am error, "value expected"
I simply want to multiply the numeric value of one cell by .555, nothing seems to work. If I could view the current formula somehow and could edit it, then all I would need to do is change the value of the number with which I am multiplying! HELP!!! :o


Top
 Profile  
 
PostPosted: Sun Jan 29, 2012 1:33 am 
Offline
SoftMaker Volunteers
SoftMaker Volunteers

Joined: Fri Dec 05, 2003 10:47 pm
Posts: 498
Location: Solingen, Germany
Select the cell content and press F2. The formula is in the field at the top.
To multiply a cell by .555, you will need something like "Table1.A1*0.555" (name of the table and name of the cell, separated by a period).


Top
 Profile  
 
PostPosted: Sun Jan 29, 2012 5:20 pm 
Offline

Joined: Fri Feb 05, 2010 8:47 pm
Posts: 8
Thank you so much! it worked! I was not highlighting the content, that is why the formula was not showing. One question, why do I need to put Table1 in the formula. I did not do that before and it worked fine.


Top
 Profile  
 
PostPosted: Sun Jan 29, 2012 11:06 pm 
Offline
SoftMaker Volunteers
SoftMaker Volunteers

Joined: Fri Dec 05, 2003 10:47 pm
Posts: 498
Location: Solingen, Germany
If the calculation is inside the same table, you don't need the table name, I suppose.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group