! 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

"Strata" wrote in message
...
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

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

"Strata" wrote in message
...
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

! 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

! in Calculations
 

sorry "data" not "date"


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