| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 6361 | 2000-11-05 07:18:00 | Excel Formula | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 6968 | 2000-11-05 07:18:00 | I want to test a number of cells which are not contiguous. I tried an 'If' statement and put the individual cells within brackets and used a comma between each cell ref.(=if((a2,b3,g14)=5,etc etc. It tells me that isn't correct (#value). If I test my formula with a contiguous range of cells using colon as the seperator it works properly. Any suggestions? | Guest (0) | ||
| 1 | |||||