A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

! in Calculations



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2005, 10:57 PM
Strata
external usenet poster
 
Posts: n/a
Default ! in Calculations

Can anyone explain to me what the ! is used for when your calculation is
puling data from another worksheet.
e.g. =+"sheet1'!B3

Thanks Strata
  #2  
Old March 10th, 2005, 10:58 PM
Fredrik Wahlgren
external usenet poster
 
Posts: n/a
Default


"Strata" wrote in message
news
Can anyone explain to me what the ! is used for when your calculation is
puling data from another worksheet.
e.g. =+"sheet1'!B3

Thanks Strata


The ! is just used as a separator token.
/Fredrik


  #3  
Old March 11th, 2005, 12:15 AM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default

And the + is not needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Strata" wrote in message
news
Can anyone explain to me what the ! is used for when your calculation is
puling data from another worksheet.
e.g. =+"sheet1'!B3

Thanks Strata



  #4  
Old December 14th, 2005, 02:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default ! in Calculations


Can Anyone help with setting up a league table in excel (for Mac) I have
a four team round robin, I want to enter scores and for the now blank
league tables to interpret date and fill out the coloumns Played, won,
drawn, goals for, goals against and points - Even if some knows the
technical term in excel for this i would appreciate it. Apologies If I
have posted this in the wrong area.

Jack


--
JackPosted from - http://www.officehelp.in

  #5  
Old December 14th, 2005, 02:15 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default ! in Calculations


sorry "data" not "date"


--
JackPosted from - http://www.officehelp.in

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations in a query...Is there a max count? HD87glide Running & Setting Up Queries 3 February 15th, 2005 07:29 AM
Date Calculations for Staff [email protected] General Discussion 1 December 10th, 2004 11:11 PM
Calculations vbc22 General Discussion 0 November 17th, 2004 11:38 PM
Perfoming calculations on answers from pervious calculations Karl Everett General Discussion 1 October 6th, 2004 02:47 PM
List Calculations Wayne Burritt Worksheet Functions 2 October 10th, 2003 04:17 PM


All times are GMT +1. The time now is 06:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.