Z
Zakynthos
If I set a cell A1 to a number between 1 and 7 to represent days of the week,
Sunday being 1 and Saturday being 7, what form will the IF/OR function take
to set a corresponding value to another C30 say "00:00" or default to
C29,say if A1 does not contain the relevant no.
Example
Sun Mon Tues Wed Thur Fri Sat
A1
1 00:00
3 00:00
5 00:00
Many thanks.
Sunday being 1 and Saturday being 7, what form will the IF/OR function take
to set a corresponding value to another C30 say "00:00" or default to
C29,say if A1 does not contain the relevant no.
Example
Sun Mon Tues Wed Thur Fri Sat
A1
1 00:00
3 00:00
5 00:00
Many thanks.