Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2011, 12:24 PM
grilem2 grilem2 is offline value attached to a name Windows 7 64bit value attached to a name Office 2010 32bit
Novice
value attached to a name
 
Join Date: Apr 2011
Posts: 2
grilem2 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-10-2011, 02:13 PM
Kimberly Kimberly is offline value attached to a name Windows 7 64bit value attached to a name Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 04-10-2011, 03:40 PM
macropod's Avatar
macropod macropod is offline value attached to a name Windows 7 32bit value attached to a name Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by grilem2 View Post
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.
As Kimberly says, names can't start with numbers - they can start with letters or an underscore. So you could define a name as _2Way, set its value to '4' (instead of using a cell reference), then reference the name via a formula. For example:
=A1*_2Way
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-15-2011, 06:46 PM
grilem2 grilem2 is offline value attached to a name Windows 7 32bit value attached to a name Office 2010 32bit
Novice
value attached to a name
 
Join Date: Apr 2011
Posts: 2
grilem2 is on a distinguished road
Default

thanks you
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
value attached to a name 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft