How to stop refer to a cell wich is empty?

I have three columns: A, B and C.

A measures Time.

B measures Temperature.

C measures ∆T.


The cells in Column C are based on the numbers in the cells in column B (ex. B5-B4), this results in misleading information unless the relevant cell in column B do contain a number. The program seems to assume that an empty cell contains the number 0, but I want that an empty cell results in no calculation at all, is that possible?

MacBook Pro 13″, macOS 10.13

Posted on Sep 21, 2020 12:32 AM

Reply

Similar questions

3 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.

How to stop refer to a cell wich is empty?

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