Write cell formula: why my formula become lower case

Help StudioX
,
1

“=MAX($Worksheet.$K:$K)”

This my formula, why my result in excel is this become =MAX($worksheet.$k:$k)

2

Hi @EMMANUEL_CAYMO

Welcome to the community!

Can you recheck the activity where you’re writing the formula in the cell?

3

I used write cell workbook

4

Hi @EMMANUEL_CAYMO

The reason for this conversion is that Excel treats function names, worksheet names, and column references as case-insensitive. It is a default behavior of Excel to convert them to a consistent case, typically lowercase, for better readability.

The formula “=MAX($worksheet.$k:$k)” will still function correctly and calculate the maximum value in the specified range. The case of the formula does not impact the calculation.

Thanks!!