如果单元格为空白，如何停止公式? [英] 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.

我的固定时间在单元格D5中，而动态时钟在单元格 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列中存在数据的情况下，才可以运行forumla?

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)

说明:如果D5 =空字符串"，则为空字符串".其他J4-D5.

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

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