! in Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...

The ! is just used as a separator token.
/Fredrik
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trailing 30 days sum calculation with excel 1
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Formula for worksheet that's tallying and pricing 5
how to calculate hrs flown in last one year 0
How To Have A Cell Be Blank If... 2
summarizing data from various workbooks 3
Macro to copy cells from one worksheet to another 1

Back
Top