Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 1st 06, 07:06 PM posted to microsoft.public.excel.misc
Tam
 
Posts: n/a
Default What does ! mean as an operator within a formula

I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates

  #2   Report Post  
Old January 1st 06, 07:21 PM posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default What does ! mean as an operator within a formula

The ! separates the worksheet name from the cell reference. The more general
form:
=[Book2]Sheet1!$A$1
The workbook name is inside the brackets, followed by the worksheet name,
the !, then the cell address.

"Tam" wrote:

I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates

  #3   Report Post  
Old January 1st 06, 07:22 PM posted to microsoft.public.excel.misc
Leith Ross
 
Posts: n/a
Default What does ! mean as an operator within a formula


Hello Tam.

An exclamation mark follows a worksheet name in formula.

Example:
=Sales!$G$20

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=497254

  #4   Report Post  
Old January 2nd 06, 08:48 AM posted to microsoft.public.excel.misc
Tam
 
Posts: n/a
Default What does ! mean as an operator within a formula



"bpeltzer" wrote:

The ! separates the worksheet name from the cell reference. The more general
form:
=[Book2]Sheet1!$A$1
The workbook name is inside the brackets, followed by the worksheet name,
the !, then the cell address.

"Tam" wrote:

I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017