如果单元格为空，如何停止公式? [英] How do I stop a formula if the cell is blank?

问题描述

如果左侧单元格中没有数据，如何停止公式运行?

How do I stop a formula from running if there is no data in the cell to the left?

我正在研究如何使用固定时间和动态时钟来显示经过的时间.

I'm trying to work out how to display elapsed time using a fixed time and a dynamic clock.

我的固定时间在 Cell D5，我的动态时钟在 Cell J4(附图片).要计算经过时间"，我的论坛如下；=J4-D5，效果很好.但是，当我将论坛复制下来时，如果单元格 D6,D8,D9 等中没有数据，那么它只会显示当前时间.

My fixed time is in Cell D5 and my dynamic clock in Cell J4 (picture attached). To work out 'elapsed time' my forumla is as follows; =J4-D5, which works fine. However, when I copy the forumla down if there is no data in cells D6,D8,D9 etc, then it will just display the current time.

是否有一些错误检查我可以做，只有在 D 列中有数据时才会运行论坛?

Is there some error checking that I can do that will only run the forumla if there is data present in Column D?

我对 excel 很陌生，所以对于菜鸟问题​​深表歉意.

I am very new to excel, so apologies for the noob question.

非常感谢

推荐答案

If(D5 = "","",J4-D5)

说明:IF D5 = "空字符串" THEN "空字符串".否则 J4-D5.

Explanation: IF D5 = "empty String" THEN "empty string". Else J4-D5.

这篇关于如果单元格为空，如何停止公式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！