The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
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
If you are in a region where the decimal separator is a comma, replace the two commas in Ian's formula with semi colons ( ; ).
IF(B3="";"";B3−B2)
Also note that the C3= in Ian's post means "Select cell C3, press = to open the Formula Editor, then enter what follows into the editor.
Regards,
Barry
Probably this is exactly it, I just get a syntax error when I program it.
Hi Dewjack,
Try this:
No formula in C2.
Formula in C3=IF(B3="","",B3−B2)
Fill down.
"" is NULL (blank).
Regards,
Ian.
How to stop refer to a cell wich is empty?
