#### Tompanilla

##### New Member

- Joined
- Nov 3, 2005

- Messages
- 47

Hi!

I have a very long formula consisting of 140 possibilities for each cell.

Is it possible to shorten it so its more easy to programme and check?

Every cell in A1 to A20 has to be checked for a number (1-20) and beside that it has to be decided which weekday cell B is.

=IF(A13=1&IF(B13="monday";K2;"")&IF(A13=1&OM(B13="tuesday";K3;"") aso.

Thanks for any suggestion

I have a very long formula consisting of 140 possibilities for each cell.

Is it possible to shorten it so its more easy to programme and check?

Every cell in A1 to A20 has to be checked for a number (1-20) and beside that it has to be decided which weekday cell B is.

=IF(A13=1&IF(B13="monday";K2;"")&IF(A13=1&OM(B13="tuesday";K3;"") aso.

Thanks for any suggestion

Last edited by a moderator: