What does this: '! mean in Excel

I am looking at an Excel sheet that has this formula in one cell: =1+'weighted avg mu'!F22 I know that the mu stands for Mark Up but I don't understand '! and I don't understand why you would add 1 to a Mark Up. I'm really confused.

May 16 '14 #1

Subscribe Post Reply

4562

Stewart Ross

2,545

Expert Mod 2GB

To the right of the bang symbol is a cell reference - F22 in this case - and to its left is the name of the worksheet concerned, which is worksheet 'weighted ave mu' in your workbook in this case.

So, 1 + 'weighted ave mu'!F22 should be read as

'in the current cell add 1 to the value of cell F22 on the worksheet named 'weighted ave mu' in this workbook.'

Excel does not attach meaning to the worksheet name - that was set by whoever named it 'weighted ave mu', not by Excel, so I would not read too much into the mu part - it might be markup, it might not, but Excel is not going to mind whatever it means.

-Stewart

May 16 '14 #2

Parmsbuddy

THANK YOU!! Now I understand!

May 21 '14 #3

aleciagibbons14

ohhh i also search that what does it mean, thanks for your shared ideas

Jun 30 '14 #4

Similar topics

what does this mean: virtual result

by: David | last post by:

Hi, Buddy, a newbie's question for you guys, In C++, some functions have a return value type "result", what does this mean, I searched on web, but no hint. thanks a lot David

C / C++

what does this mean?

by: pete | last post by:

I found it in the view source of a corporate website. <script Language="Javascript">  </script>

Javascript

what does 'this' mean if it static

by: opistobranchia | last post by:

I was on a job interview and the interviewer asked what "this" meant. I replied it represented this class like cout << a or cout << this.a then he asked what this meant if it was static? I...

C / C++

What does this mean: External component has thrown an exception.

by: **Developer** | last post by:

What does this mean: External component has thrown an exception. My program crashes after it leaves a subroutine. What I see during debugging is when I press F11 at the End Sub statement

Visual Basic .NET

what does this mean again...

by: =?Utf-8?B?cm9kY2hhcg==?= | last post by:

hey all, in a web.config, what does the following mean? allow users="*" Does this mean all intranet users? thanks, rodchar

ASP.NET

What does this mean? how do I put that right?

by: > Adrian | last post by:

What does this mean / how do I put that right? Warning 2 Build input parameter 'SupportUrl=www.???.nl' is not a web url or UNC share. C:\___ TRIAL BUDGET VISTA V2005...

C# / C Sharp

What does this mean?

by: JoeC | last post by:

m_iWidth = (int)pBitmapInfo->bmiHeader.biWidth; m_iHeight = (int)pBitmapInfo->bmiHeader.biHeight; What does this mean? I have seen v=&var->member.thing; but what does it mean when you...

C / C++

<Identifier> expected ---> What does this mean???

by: CodeTilYaDrop | last post by:

I am still pretty new to programming, and I sometimes can not figure something out. I am getting an error with this line in my program: Public void count_syllables(int count_syllables) I get...

Java

what does this mean

by: Bint | last post by:

I'm getting this returned from a PHP script. What does this mean? <b>Parse error</b>: syntax error, unexpected ')', expecting T_PAAMAYIM_NEKUDOTAYIM in <b>/ho Thanks B

PHP

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware