Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking for some help with code to evaluate a cell.
When I evaluate a cell, if it contains one of 15 accounts, I have to evaluate another cell (same row, column b) to be sure it (the second cell) is not empty. If it (the second cell) is empty, then a message will be displayed in column K. The part I'm having trouble with is the syntax to see if the first cell (account) is either 101, 102, 105, 107..etc. I could string together a bunch of If / Or statements but there must be a better way. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Evaluating a group of cells | Excel Discussion (Misc queries) | |||
Changing items in cells that are filled using Data Validation List | New Users to Excel | |||
evaluating text of cells | Excel Discussion (Misc queries) | |||
I have a question about adding information to a list of items that have cells linked to another worksheet. | Excel Discussion (Misc queries) | |||
If formula evaluating 2 cells contents | Excel Worksheet Functions |