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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
! 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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
! 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
|
|||
|
|||
! in Calculations
|
Thread Tools | |
Display Modes | |
|
|
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 06:29 AM |
Date Calculations for Staff | [email protected] | General Discussion | 1 | December 10th, 2004 10:11 PM |
Calculations | vbc22 | General Discussion | 0 | November 17th, 2004 10: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 |