Formulas

Actual Version: 4.2.0

Formulas

Show your tables as they are.
Show the formulas
And much more…
If you are using Excel Jeanie Html for a forum / messageboard, you want to show your formulas and more details.
In the register Forum you can decide, how and wether things are displayed.

Ex1: Formula

Formulas

	A	B	C	D	E	F
4
5		Article	Amount		Sum nails
6		Nails	23,51		70,53
7		Hammer	54,23
8		Hammer	55,23
9		Nails	23,51
10		Nails	23,51
11

Spreadsheet Formulas

Cell	Formula
E6	=SUMIF(B6:B10,"Nails",C6:C10)

Ex2: Show conditional formatting formulas:
Conditional

	B
2	15
3	20
4	30
5	13

Conditional formatting

Cell	Nr.: / Condition	Format
B2	1. / Cell Value greater than 15	Abc
B3	1. / Cell Value greater than 15	Abc
B4	1. / Cell Value greater than 15	Abc
B5	1. / Cell Value greater than 15	Abc

Ex3: Show Array with hint to array.
And color the brackets if you wish
Array

	B	C
2	Number	Sum of the digits
3	12345	15

Spreadsheet Formulas

Cell	Formula
C3	{=SUM(1*MID(B3,ROW(INDIRECT("1:"&LEN(B3))),1))}

Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!

Ex4: Show names you use in your formulas:
Names

	A	B	C	D	E
1
2		22
3				550
4

Spreadsheet Formulas

Cell	Formula
D3	=Test*25

Names in Formulas

Cell	Name	Applies to
D3	Test	=Names!$B$2

And and and ... try yourself!

Top Home