maxsp

Previous chapterNext chapter Show allShow all    Hide allHide all

The function minsp finds the highest value in a range und formats it. The format can be a colour or underlined.

Syntax: = maxsp(range,num)

Transfer parameters

Valid range

Comment

range

A1-ATWH31000

num

[-1;0 - 15]

-1 = underlined
0..15 = color from listbox in font dialog

Example Example

Cell C1 = maxsp(A1:B4,-1)

R / C

A

B

C

1

8

5

2

20

2

3

12

10

4

32

14