Numbers, need help with a function

i would love to make the B Column to be filled only when i write into the A column, is that possible ? probably yes but i dunno how

iPhone 12

Posted on Oct 7, 2023 6:34 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 7, 2023 7:05 AM

Look carefully:


Also, there shouldn't be a space between the "" so it can be used as 0 in other calculations.

=IF(ISBLANK($A2),"",10−$A2)


When people post formulas, just copy them, then in the cell type = and paste. You will avoid transcription errors.

6 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers, need help with a function

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.