excel中单元格的条件公式 [英] conditional formula for the cell in excel

问题描述

Hai，





我有一张excel表，其中包含几列。

Hai,


I have a excel sheet which contains few columns.

Event Date     Holder	        Name            Validation
10/30/2013    Entry Granted  YUVARAJ             FALSE
10/30/2013    Exit granted   YUVARAJ             FALSE

我把上面的列放在单元格A和B中的excel文件中。



假设下一行是空行（即）Cth row然后如何将验证设置显示为true.Plz帮助我。





提前致谢。

I have put the above columns in the excel file in the cell A and B.

Suppose if the next row is empty row (ie) Cth row then how can i display the validation set to "true".Plz help me.


Thanks in advance.

推荐答案

类似于：

Something like:

=IF(ISBLANK(A2), "TRUE","")

使用Excel帮助菜单项可以找到很多有用的信息。

Using the Excel help menu item will find you lots of useful information.

你要找的功能是 ISBLANK



例如在单元格D4中有一个单元格公式 = ISBLANK （C4），D5有 = ISBLANK（C 5）等等



我个人认为验证设置为 TRUE 如果数据 WAS 进入，在这种情况下我会使用公式 = NOT（ISBLANK（C4））



很容易被多个isblank函数绑定，尤其是本地化，日期，其他公式等...这组搜索结果提到了几个 google搜索isblank问题 [ ^ ]但我不担心它们除非/直到你击中它们



最后，请注意你的术语（这样更容易让更多人帮助你）

The function you are looking for is ISBLANK

For example in cell D4 have a cell formula =ISBLANK(C4), D5 has =ISBLANK(C5) etc etc

Personally I would have had the validation set to TRUE if the data WAS entered in which case I would have used the formula =NOT(ISBLANK(C4))

It is very easy to get tied up with multiple isblank functions especially with localisation, dates, other formulas etc etc ... this set of search results mentions several google search for isblank issues[^] but I wouldn't worry about them unless/until you hit them

Finally, be careful about your terminology (so that it is easier for more people to help you out)

会员10234093说：

Member 10234093 said:

我把上面的列放在单元格A和B的excel文件中。

I have put the above columns in the excel file in the cell A and B.

。你实际上是说你已将数据放在第2行和第3行中，其中第1行是标题行。



所以...

行有数字 - 通常这些都显示在左侧

列有字母 - 通常显示在表格的顶部

单元格由其列+行标识，例如C4以上。

. You actually meant that you have put the above data in rows 2 and 3 where row 1 is the headings row.

So ...
rows have numbers - usually these are displayed down the left hand side
columns have letters - usually displayed across the top of the sheet
cells are identified by their column + row e.g. C4 above.

这篇关于excel中单元格的条件公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！