How to get " =C2^3-NN" in calc?

[altair]

Hello!
I am worried how t oget the hell "=C2^3-NN in calc!!!
The problem is if I try, i get just "C2³ instead, TOO DIRECTLY, TOO RIGHT!!!
And I get #name when I try to imput/count it!!!

Whe the hell have I done wrong now, I am asking myself!!!

Many thanks!

[razon_22]

The problem is with NN. It needs to be a cell reference (like N3) or a number.

[w_whalley]

NN can also be a range name for a cell that contains a number.

[JohnSUN]

Here altair said that he means that “NN is the name of other cell containing number”

[razon_22]

Thanks @JohnSUN. @altair, I just tested the formula in version 4.1.1.2 and it works correctly. Since C2^3 is working, the issue may be in the named range. Try the formula in a blank spreadsheet to ensure LibreOffice is working as it should.