Using labels in formulas

[Sharon]

How would I write the following formula using labels?

=MAX(B13:E13)

 

[Peo Sjoblom]

=MAX(Labels)

check accept labels in formulas under tools>options>calculations

 

[Bernard Liengme]

HI Sharon,
Peo has given you the exact answer but I am wondering if you know the
difference between 'labels' and 'range names'
Select B13:E13 and type a name in the name box (to left of Formula Box) , a
name such as Apple
In F1 enter =MAX(apple)

Best wishes