Formula editor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joris 3 Pinter - 20 Dec 2006 20:04 GMT

Everyone gets to see formules like this one sooner or later:

A2: =IF(AND(A1=0;B3=1);IF(C17=C18;2;3);IF(OR(D12=1;D12=D13);4;5))

When jou put a remark to a cell, the remark will show when crossing
the cell with your mouse.
Why not something like that with a kind of Excel formula editor?
So, moving the mouse over cell A2, the cell with the formula,
and a window will show like this:

IF (A1=0 AND B3=1) THEN
BEGIN
IF C17=C19 DAN
BEGIN
CELL=2
END
ELSE
BEGIN
CELL=3
END
END
ELSE
BEGIN
IF (D12=1 OR D12=D13) THEN
BEGIN
CELL=4
END
ELSE
BEGIN
CELL=5
END
END

I think this is much easier to read. And, if this is made, also a possibilty
to
edit the formula and after entering you will have the original excel formula
again.

I think it is possible but I do not have the time to make it.
Joris.

Reply to this Message

KC Rippstein - 20 Dec 2006 20:46 GMT

You can use Alt+Enter and indenting spaces to break the formula up
vertically. This allows anyone who selects that cell to see the formula
vertically like you would write programming code instead of a horizontal
garbled mess. Always indent at least 2 spaces to break things up; if you
use 3, 4, or 5 spaces for each break in thought, use that consistently
throughout. Here I used 4 spaces each time, and while it may not explain
"begin" & "end" or "if...then...else" it is still much easier to follow. I
also love to use naming conventions as much as is reasonable (if I'm
multiplying cost_Pepsi by inventory_Pepsi, everyone understands what we did
to get to the total value of my Pepsi inventory).

=IF(
AND( A1=0 ; B3=1 );
IF(
C17=C18;
2;
3 );
IF(
OR( D12=1 ; D12=D13 );
4;
5 )
)

> Everyone gets to see formules like this one sooner or later:
>
[quoted text clipped - 36 lines]
> I think it is possible but I do not have the time to make it.
> Joris.

Reply to this Message

Joris 3 Pinter - 20 Dec 2006 21:09 GMT

YES!!!!!!!!

Never knew this was possible and it is nearly the same effect of what I
suggested...

Thanks for the idea!
Joris.
(Still a formula editor would be convenient...)

> You can use Alt+Enter and indenting spaces to break the formula up
> vertically. This allows anyone who selects that cell to see the formula
[quoted text clipped - 59 lines]
>> I think it is possible but I do not have the time to make it.
>> Joris.

Reply to this Message

Rate this thread: