Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a HUGE spreadsheet and want to blank out certain cells based upon a
test to see if other cells are also blank. For example: A B C 1 .5 3 2 .1 0 3 0 4 .3 1 It is easy enough to place an IF statement in column C to test to see if the cells in column A are blank, which A3 is in this example. But what I want to do is to use an IF statement (or something else) to write a blank over the corresponding cell in column B if the cell in column A is also blank. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statements | Excel Worksheet Functions | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
IF and MAX statements | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions | |||
If statements | Excel Discussion (Misc queries) |