| View previous topic :: View next topic |
| Author |
Message |
CakeBandit
Newbie
Joined: 25 Dec 2009
Posts: 2
|
 Posted: Fri Dec 25, 2009 9:55 am Post subject: Formula Help |
 |
|
Need help and puzzled...... I have made a defined word - 'New Hire' and assign it to cell A1, then put a value of $12.00 in Cell A1.
What I want is to type --->'New Hire' into any cell and have it automaticaly have the value defined of Cell A1. Is this possible? Thanx in advance |
|
| Back to top |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
| Posted: Fri Dec 25, 2009 2:03 pm Post subject: |
|
|
If you Ctrl+F3 and assign New_Hire to $A$1 then you can type =New_Hire into the formula box for any cell and it will enter the value of A1 into that cell.
Otherwise you will need to use AutoCorrect to replace "New Hire" with =A1.
You cannot, as far as I know, enter data into a cell containing a formula expecting that formula to act on that data entered.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot) |
|
| Back to top |
|
|
CakeBandit
Newbie
Joined: 25 Dec 2009
Posts: 2
|
| Posted: Fri Dec 25, 2009 5:51 pm Post subject: |
|
|
| Thanks that worked. |
|
| Back to top |
|
|
|
