Formulas show column headings rather than cell designation.

Question

DAR3198 Author

Level 1

4 points

Formulas show column headings rather than cell designation.

I know this behavior can be changed in preference on a Mac but how do I change it on an iPad. ?

cell references read

IF('-701' 'Thu, Jul 25, 2024'>"0",'-701' 'Thu, Jul 25, 2024'÷(J214×Buy 'Thu, Jul 25, 2024'),"")

instead of

IF(M214'>"0",M214÷(J214×I214),"")

iPad, iPadOS 17

Posted on Jan 27, 2025 10:02 AM

Reply

Answer 1

Camelot

Level 9

58,299 points

Jan 27, 2025 1:43 PM in response to DAR3198

That's a really good question, and not something I'd really noticed before, but Numbers on iOS does not seem to have an control over this in the same way that Numbers on MacOS does - it defaults to named references.

Your next port of call may be: Feedback - Numbers for iOS and iPadOS - Apple

Reply

Formulas show column headings rather than cell designation.

Similar questions