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.

Hi,

your question is not clear.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Zakynthos" wrote in message
...
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.

I am unsure of your question but:
Enter some value (1 to 7) in A1
Type this formula into B1 and copy it to H1
=IF($A$1=COLUMN()-1,"X","")
Experiment with A1. Are we close to what is wanted?

We could change formula to:
=IF($A$1=COLUMN()-1,C30, C29)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Zakynthos" wrote in message
...
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.