Excel Formular Symbol Help

Question

1.00/5 (1 vote)

See more:

Hi All,

I am just reviewing some formulas in an excel sheet that i have just been handed . Once i have reviewed these formulas I will some how need to code them in the project i am currently working on.

Now, I have come across a particular cell which contains a formula that i'm finding hard to understand and I hope some one on here will be able to explain it to me in simpler terms. The formula is as follows:

Quote:
=F10-C10-I10

Now according to my understanding is: the value in F10 cell is subtracting the value in C10.. now the last Is where i am stuck , I don;t understand the

Quote:
-I10

bit. Does that vertical dash mean anything special in excel?

Thank you for your time and help!

Posted 4-Mar-15 3:34am

1Future

Add a Solution

Comments

hypermellow 4-Mar-15 9:41am

Is the 'vertical dash' the letter I? ... meaning the value of cell I10 is also subtracted?

1Future 4-Mar-15 9:51am

It IS I .. lol sorry .. but thank you for opening my eyes!!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2015-03-04T03:43:00

Solution 1

It's I10, as in column I row 10.

In fact if you go into edit mode in a cell like that you should get highlights around each of the cells that are involved and you should see all 3.

The formula is subtracting cell I10 from cell C10 and then subtracting that from cell F10.

Posted 4-Mar-15 3:43am

ZurdoDev

Comments

1Future 4-Mar-15 9:51am

lol it is I .. Thank you sirr!

ZurdoDev 4-Mar-15 9:51am

No problem. ;)

Sergey Alexandrovich Kryukov 4-Mar-15 10:44am

Ha-ha, this is the cell coordinate {verticalDash,10}. 5ed.
—SA