Home |
Search |
Today's Posts |
#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 ... 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 ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
! 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
! in Calculations
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
Updating calculations + graph when i enter in new data WITHOUT OFF | Excel Worksheet Functions | |||
calculations from data in other worksheets | Excel Worksheet Functions | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |