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.

推荐答案

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

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

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

会员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中单元格的条件公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！