[.... deleted by me .... I like Jonmo1's formula better ]
Type: Posts; User: joeu2004; Keyword(s):
[.... deleted by me .... I like Jonmo1's formula better ]
I would advise against responding constructively.
There have been at least two other threads with similar questions, perhaps in the "other" forum. I regret that I contributed to one of those...
Well, that is correct. But I meant to put the caveat after the ISNUMBER expression.
The point is: if we put a comma after the value-if-true part, the missing value-if-false will be interpreted...
It is difficult to say what the problem is unless you post your formula. Ideally, upload an example Excel file to a file-sharing website and post the download URL here, so we can see the data that...
Caveat: AhoyNC used STDEV.S (aka STDEV). That is an approximation of the standard deviation of a larger population (set of numbers), based on the assumption that the selected numbers are a...
You're welcome. Given your changes, the following might be helpful.
-----
With a fixed withdrawal amount, you can use NPER to calculate the number of years for the withdrawal phase, to wit (in...
It is unclear to me exactly what you want to calculate. Perhaps something like the following.
<tbody>
A
B
C
.... Unless you have a priori knowledge of the number of digits that precede the "E"?
If you know, describe the syntax of all text that Excel might interpret as a number, and I'm sure that someone...
For your example, I know. I was just describing the general problem in order to explain why opening CSV files directly is not a good idea if your intent is for part of it not to be interpreted by...
That is incorrect. As long as the data looks like 135087E67 in the cell when you save as CSV, Excel writes 135087E67 into the file. Open the file with Notepad to confirm.
The problem is: a CSV...
If all the data that should be text are the entire content of their respective columns, it is better to import the CSV file instead of opening it directly in Excel.
Otherwise, if any of your IDs...
Not exactly. If you look at the IF support page, we see the same list, not mentioning Excel 97, let alone Excel 2003, to wit:
Do you really believe that means the IF function was introduced...
That is incorrect!
First, when we save as "xls" in Excel 2010, the compatibility checker does not flag the use of SUBSTITUTE. In contrast, it does flag the use of COUNTIFS.
Second, I still...
Thanks FormR and Peter. Rick's article is definitely a keeper. Just an observation.... I'm a big fan of explaining assumptions, for the benefit of the unsuspecting user. The TRIM/REPT paradigm...
Thanks for the ideas, Fluff and DanteAmor.
I have the abstract string "firstString/secondString/thirdString/fourthString" in C2.
I want to use a single Excel formula (not VBA; no helper cells) to extract "secondString". Any ideas?
Note...
I have not studied the formula, but my first impression is: did you array-enter the formula by pressing ctrl+shift+Enter instead of just Enter?
I suspect that is necessary in order for the...
This is due to the difference between "simple" interest and "compound" interest.
Your SUM formula is calculating "simple" interest based on the initial balance (G5). In other words, you earn...
As you say, one Custom format is of the form postive;negative;zero.
So perhaps you want: ;-General;General
Change "General" to any specific format that you want. And omit the last ";General"...
I explained all this in response #2 , posted 20 minutes earlier.
First, you are not "converting" to text when you change the format to Text. Proof: ISNUMBER(A1) is TRUE after changing the format...
But simply changing a numeric format (General, Number, etc) to Text, as Leza is doing, does not "convert it to text".
And the appearance after changing the format to Text depends on how the number...
I don't know what Home > Number does in your version of Excel. In my version, you might be talking about the feature on the ribbon that selects the cell format. Note that it selects a format for...
We don't know; you tell us(!). After 345 posts, I think that you should know how to ask a question about formula behavior by now, in order to get the quickest and most applicable response.
At a...
I do not see 220175 or any of the 3xxxxx product numbers (D2:D15) in A2:A139 of the "New Prices" worksheet.
I suspect that is true in many/most/all cases.
I do not see 714116 in both...
Hmm, if you are using a Mac, I would think that the 1904 option is enabled already. Or did you receive the file from a Windows user?
Anyway, yes, the 1904 option is entirely appropriate to use on...