IF and OR function

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top