2013 Archives by date, by thread · List index

# Re: [libreoffice-users] Calc Function Wizard - IF Result differences

```Let me rather put it this way: I don't think using VLOOKUP solves the
underlying problem, which is that too much is being done in one
formula.

For any complicated formula, I feel the best solution is either a
custom written user function, or intermediate steps in columns. Hide
those columns, or put them on another worksheet if you don't want to
see them, but they should still be there. Makes things much easier.

Paul

On Mon, 21 Oct 2013 15:04:34 +0200
Paul <paulsteyn1@afrihost.co.za> wrote:

```
```On Mon, 21 Oct 2013 14:32:40 +0200
"Hylton Conacher (ZR1HPC)" <hylton@conacher.co.za> wrote:

```
```appreciated especially as he also indicates that using VLOOKUP would
not work, in this case. MIN and MAX are still under testing here :)
```
```Brian indicated that VLOOKUP would work; I don't say different, I'm
just not sure how in this situation. I'm not that familiar with
VLOOKUP though, so it may not be that difficult, but it seems like it
would still be complicated. I still feel that the best approach is to
put columns for intermediate steps; VLOOKUP might make more sense
after that.

```
```I am however still waiting for someone to indicate to me which part
of the formula in the Formula Wizard the boxes apply i.e. what is
the difference between the 'Result' and 'Function Result' answer
box.
```
```The "Result" box shows the result of the complete formula for the
cell, while the "Function Result" box shows the result of just the
function currently under the cursor. For example, let's say you have
typed "=SQRT(SUM(A1:A2))", and A1 was 4 and A2 was 5. If you put your
cursor on "SQRT", both boxes would hold the answer 3, as that is both
the final result of the formula, and the result of "SQRT(9)". If,
however, you put your cursor on "SUM", then the "Result" box would
still show 3, as that is still the result of the complete formula,
but the "Function Result" box would now hold 9, as that is the result
of "SUM(A1:A2)".

Paul

```
```

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
```