Using multiple"if" "ands'
Posted on 2014-09-22
Golf tee times.
I have a column "I" that has day name in it i.e. Mon thru Sun.
I have other column "J"that has time in it 0700-1900
I want to show a return value of "T1", "T2", "T3", "T4", "T5"
i.e if ($I14="FRI" and $J14>TIME(10,50,0) then $K14="T1" else "T2")
I need to do this for all seven days. some days have 3 time conditions and 3 'return values.
if ($I14="SUN" and $J14>TIME(10,50,0)<TIME(14,30,0) then $K14="T3" else "T2")
Above probably does not explain well:
5 Time values
T1-T5 represent values.
If a golfer plays before 1050 on a Saturday that would need to show T1
If a golfer plays after 1051 and before 1700 on a Saturday that would need to show T2
If a golfer plays after 1700 on a Saturday that would need to show T3
So I need to determine the "DAY" from column I and then do the if for each day.
Trying to use one formula for all seven days.
I have wrestled with this for about a month, I can not get it to work for all seven days.
Any direction is appreciated....