Search:

Type: Posts; User: joeu2004; Keyword(s):

Page 1 of 6 1

1. Thread: Simple Algebra calculation for variable

by joeu2004
Replies
4
Views
85

Re: Simple Algebra calculation for variable

Of course, you could solve it algebraically. Enter the following formula into X1 (e.g):

=(500 - 10) / 1.1 / 1.05

But when you're at a loss as to how to solve a problem algebraically, you could...

by joeu2004
Replies
1
Views
71

Re: Excel amortization calculation

You can post an image by creating a local jpg file, then uploading it to a image-sharing website (I use postimages.org), and copy-and-pasting the URL for forums or clicking the Insert Image icon to...
3. Thread: Sum column using NOT equal to criteria

by joeu2004
Replies
4
Views
118

Re: Sum column using NOT equal to criteria

[.... deleted by me .... I like Jonmo1's formula better ]

by joeu2004
Replies
1
Views
103

Re: Binary Data

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...

by joeu2004
Replies
6
Views
185

Re: Standard Deviation Function

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...

by joeu2004
Replies
6
Views
185

Re: Standard Deviation Function

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...

by joeu2004
Replies
6
Views
185

Re: Standard Deviation Function

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...
8. Thread: Calculate Growth Value When Drawing Down Funds

by joeu2004
Replies
4
Views
217

Re: Calculate Growth Value When Drawing Down Funds

-----

With a fixed withdrawal amount, you can use NPER to calculate the number of years for the withdrawal phase, to wit (in...
9. Thread: Calculate Growth Value When Drawing Down Funds

by joeu2004
Replies
4
Views
217

Re: Calculate Growth Value When Drawing Down Funds

It is unclear to me exactly what you want to calculate. Perhaps something like the following.

<tbody>

A
B
C
10. Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
393

Re: Convertic scientific notation to text format

.... 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...
11. Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
393

Re: Convertic scientific notation to text format

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...
12. Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
393

Re: Convertic scientific notation to text format

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...
13. Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
393

Re: Convertic scientific notation to text format

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...
14. Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
326

Re: Excel formula (not VBA) to extract delimited string?

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...
15. Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
326

Re: Excel formula (not VBA) to extract delimited string?

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...
16. Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
326

Re: Excel formula (not VBA) to extract delimited string?

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...
17. Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
326

Re: Excel formula (not VBA) to extract delimited string?

Thanks for the ideas, Fluff and DanteAmor.
18. Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
326

Excel formula (not VBA) to extract delimited string?

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...

by joeu2004
Replies
4
Views
135

Re: Index Error

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...

by joeu2004
Replies
4
Views
116

Re: Future value formula

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...
21. Thread: hiding only +ve numbers

by joeu2004
Replies
2
Views
73

Re: hiding only +ve numbers

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"...
22. Thread: numbers to text and text to numbers

by joeu2004
Replies
13
Views
223

Re: numbers to text and text to numbers

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...
23. Thread: numbers to text and text to numbers

by joeu2004
Replies
13
Views
223

Re: numbers to text and text to numbers

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...
24. Thread: numbers to text and text to numbers

by joeu2004
Replies
13
Views
223

Re: numbers to text and text to numbers

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...

by joeu2004
Replies
5
Views
159

Re: Help with explaining this formula, Please

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...
Results 1 to 25 of 150
Page 1 of 6 1