ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what does '- do in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/168161-what-does-do-cell.html)

sc16

what does '- do in a cell?
 
i'm trying to indicate that there is no relation cost between an origin and a
destination however 0 would not indicate this as zero would indicate that the
cost = $0.. what can i put into a cell to let it know that no relation exists
when i want to use the solver tool? also, what exactly does '- mean in a
cell?

Chip Pearson

what does '- do in a cell?
 
You might try using =NA() to return a #N/A value. The ' apostrophe
character at the beginning of the text in a cell tells Excel to treat the
following content as literal text, not to be translated. For example, if you
enter 1/2/34 in a cell, Excel translates it to the date 2-Jan-1934 (or
1-Feb-1934 depending locale settings). If you precede this entry with an
apostrophe, Excel treats it as literal text and does not convert it to a
date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"sc16" wrote in message
...
i'm trying to indicate that there is no relation cost between an origin
and a
destination however 0 would not indicate this as zero would indicate that
the
cost = $0.. what can i put into a cell to let it know that no relation
exists
when i want to use the solver tool? also, what exactly does '- mean in a
cell?



sc16

what does '- do in a cell?
 
Hey Chip,

Unfortunately that doesn't work either! =( but thanks for the thought..
appreciate it =)

"Chip Pearson" wrote:

You might try using =NA() to return a #N/A value. The ' apostrophe
character at the beginning of the text in a cell tells Excel to treat the
following content as literal text, not to be translated. For example, if you
enter 1/2/34 in a cell, Excel translates it to the date 2-Jan-1934 (or
1-Feb-1934 depending locale settings). If you precede this entry with an
apostrophe, Excel treats it as literal text and does not convert it to a
date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"sc16" wrote in message
...
i'm trying to indicate that there is no relation cost between an origin
and a
destination however 0 would not indicate this as zero would indicate that
the
cost = $0.. what can i put into a cell to let it know that no relation
exists
when i want to use the solver tool? also, what exactly does '- mean in a
cell?



JLGWhiz

what does '- do in a cell?
 
I think Chip missed the - in your question. However, what he said still
holds true for that condition. The ['-] means don't treat this as a
numerical operator, but as a short dash.

"sc16" wrote:

Hey Chip,

Unfortunately that doesn't work either! =( but thanks for the thought..
appreciate it =)

"Chip Pearson" wrote:

You might try using =NA() to return a #N/A value. The ' apostrophe
character at the beginning of the text in a cell tells Excel to treat the
following content as literal text, not to be translated. For example, if you
enter 1/2/34 in a cell, Excel translates it to the date 2-Jan-1934 (or
1-Feb-1934 depending locale settings). If you precede this entry with an
apostrophe, Excel treats it as literal text and does not convert it to a
date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"sc16" wrote in message
...
i'm trying to indicate that there is no relation cost between an origin
and a
destination however 0 would not indicate this as zero would indicate that
the
cost = $0.. what can i put into a cell to let it know that no relation
exists
when i want to use the solver tool? also, what exactly does '- mean in a
cell?




All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com