Re: IF and OR function
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Mon, 3 Nov 2008 09:51:15 -0400
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" <Zakynthos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC8ED718-1E8C-4AA5-85F6-13760768CCAC@xxxxxxxxxxxxxxxx
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.
.
- References:
- IF and OR function
- From: Zakynthos
- IF and OR function
- Prev by Date: Re: maxif
- Next by Date: RE: Changing the incrementation when "puliing" cell values down a
- Previous by thread: Re: IF and OR function
- Next by thread: RE: need help on count entires with conditions
- Index(es):
Relevant Pages
|
