Quick Excel question

[Delita]

I want to use some sort of binary expression to show that if one cell contains something then another cell will show some specified text. So something along the lines of

=if(cell contains content then "OK", cell is empty "Error")

Any suggestions?

 

[mayest]

Sure, you can use the IsBlank() function to test for an empty cell. So, this should do the trick:

=If(IsBlank(A1), "Error", "OK")

There are several other Is* functions that might be useful: IsErr, IsError, IsLogical, IsEven, IsOdd, IsNA, IsNumber, IsNonText, IsText, IsRef. Depending on your version of Excel, you may need the Analysis ToolPak add-in installed to have access to some of those.

 

[Delita]

Originally posted by: mayest
Sure, you can use the IsBlank() function to test for an empty cell. So, this should do the trick:

=If(IsBlank(A1), "Error", "OK")

There are several other Is* functions that might be useful: IsErr, IsError, IsLogical, IsEven, IsOdd, IsNA, IsNumber, IsNonText, IsText, IsRef. Depending on your version of Excel, you may need the Analysis ToolPak add-in installed to have access to some of those.

Cool. Thanks