#1
|
|||
|
|||
value attached to a name
is it possible to have a name in a cell such as 2-way and have a fixed value say -4 attached to it?? so if i type 2-way in a cell the formula will automatically use that value. |
#2
|
|||
|
|||
Names cannot begin with numbers, so pick a different word. They can't contain spaces either, by the way.
Click 'Define Name' on the Formulas tab of the Ribbon. Type the desired name (TwoWay, for example) and change the reference (it will have a cell address in there) to =4 |
#3
|
||||
|
||||
Quote:
=A1*_2Way
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
thanks you
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
3 Simple Questions (screenshots attached) | smaan | Word | 1 | 03-08-2011 12:46 AM |
Problem: Open attached Word file | markg2 | Outlook | 0 | 02-09-2011 09:18 AM |
Hyperlink to attached file in email message | spino | Outlook | 0 | 08-05-2010 05:56 AM |
Macro to determine attached template | zippyaus | Word VBA | 0 | 03-02-2010 02:05 AM |
Outlook xp slow when Browsing to attached a file | jmelgar1 | Outlook | 0 | 09-23-2008 01:49 PM |